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 formulas with the help of the built-in option that is already available in the Excel Options wizard in Microsoft 365.
Excel is one of the best tools that can be used by almost anybody. From creating a Pie chart to calculating simple interest. As Excel users often require to know formulas to perform a specific job, this tool shows a list of potential formulas when the user starts typing. The list appears when you type something related to a formula. For example, check out the following image-
As the text starts with =, Excel starts showing the formulas in a list format. In most cases, it is handy as it allows users to choose a formula quickly. However, some folks might not like it like everyone else. If you are one of them, you can disable this functionality with the help of this guide.
How to hide a list of formulas while typing in Excel
To show or hide a list of formulas while typing in Excel, follow these steps-
- Open Excel on your computer.
- Click the File.
- Go to Options.
- Switch to the Formulas tab.
- Remove the tick from the Formula AutoComplete checkbox.
- Click the OK button.
To learn more about these steps, continue reading.
Open the Excel on your computer first. Now, click the File option that is visible on the top-left corner of your screen. On the next page, you can see a button called Options. You need to click on it.
By default, you are in the General tab, but you need to switch to the Formulas tab. After that, you can see a checkbox named Formula AutoComplete that appears in the Working with formulas section. You need to remove the tick from the corresponding checkbox and click the OK button to save the change.
Once you are done with the last step, you can no longer see the autocomplete list of formulas while typing in an Excel spreadsheet.
For your information, you can show or hide this autocomplete list with the help of a keyboard shortcut as well. You can press the Alt+Down arrow to get the job done.
That’s all! Hope it helps.
Read: How to add parentheses in Excel
How do I hide formulas behind text in Excel?
To hide the formula behind the text in Excel, you need to click on the Format option available in the Home tab. Then, click on the Format Cells option and go to the Protection tab. Next, tick the Hidden checkbox and click the OK button. Alternatively, you can right-click on the cell and select the Format Cells option.
How do I hide formulas in Excel until data is entered?
To hide formulas in Excel until the data is entered, you need to enable the Hidden option. For that, right-click on the cell and select the Format Cells option. Next, switch to the Protection tab and find the checkbox saying Hidden. Then, tick the corresponding checkbox and save the change. However, you must protect the worksheet in order to make this option work.
