If you want to show or hide the list of formulas while typing in an Excel spreadsheet, here is how you can do that. You can enable or disable the autocomplete of ...

If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled range. Simply reference the first cell of the spilled range with a # ...