Want to show formulas in Excel? Want to hide formulas in Excel? It is not difficult to do these jobs. MiniTool Software collects some useful methods and shows them in this post. In addition, if you want to recover your lost Excel files, you can try MiniTool Power Data Recovery .
Show or Hide Formulas in Excel
You can use formulas in Excel to quickly make some calculations. The cells will only show the results rather than the formulas after you make the formula work (press the Enter key). However, it is easy to show or hide formulas in Excel. In this post, we will show you some easy methods for different situations.
Way 1: Use Your Mouse and Keyboard
If you want to show the formula in a single cell, you can just double-click that cell. Then, you can see that the formula is displayed. To hide that formula, you need to press the Enter key on your keyboard.
When the formula appears in the cell, you should not click any other cell because it will change the reference in the formula.
Way 2: Switch between Displaying Formulas and the Results via the Top Ribbon
Microsoft Excel itself has a built-in feature that can make your Excel show formulas in cells. You can find it in the top ribbon menu. This feature will display all formulas in your Excel.
Here is how to display formulas in Excel using this method:
Step 1: Open your worksheet, the click Formulas from the top ribbon menu.
Step 2: Click the Show Formulas button in the Formula Auditing group.
All cells that use formulas will show up the formulas.
Well then, how to hide formulas in Excel? You just need to click the Show Formulas button again, then the cells will only show the results.
Do you know how to merge or unmerge cells in Excel without losing data? In this article, we will show you some useful guides.
Way 3: Switch between Displaying Formulas and the Results Using the Keyboard Shortcut
You can also directly use the keyboard shortcut to show or hide formulas in Excel. It is very easy to do this: you just need to press the Ctrl and ` keys at the same time. The ` key is under the Esc key in most cases. To hide formulas in cells, you can just press Ctrl + ` again.
The Show Formulas button will be highlighted after you press Ctrl + `.