How to display formulas in excel

At work, we will edit existing formulas and need to display the formulas for inspection. How to display the formulas?

How to display formulas in excel:

First open a sample workbook and prepare to display the formulas contained in it

Then left-click the "Formula" tab at the top of the interface (pointed by the red arrow in the picture)

Then click "Formula Review" The "Show Formulas" button in the function group (red box in the picture) (pointed to by the red arrow in the picture)

The formulas in the visible worksheet are displayed (red in the picture) Box)

If you want to restore the data display, click the "Show Formula" button (pointed by the red arrow in the picture) with the left mouse button, and the data will be restored. Display (red box in the picture)

Note: You can also use the keyboard’s “Ctrl ~” shortcut key to display the formula

More Excel related technologies Article, please visit the Excel Basic Tutorial column to learn!

The above is the detailed content of How to display formulas in excel. For more information, please follow other related articles on the PHP Chinese website!