Home  >  Article  >  Topics  >  How to display formulas in excel

How to display formulas in excel

藏色散人
藏色散人Original
2019-06-18 10:36:3828741browse

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

How to display formulas in excel

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

How to display formulas in excel

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)

How to display formulas in excel

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

How to display formulas in excel

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)

How to display formulas in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn