When editing an Excel file with multiple formulas, it is sometimes useful to switch between Excel's normal display, which shows the results of the formulas in the spreadsheet, and a display mode that shows the actual formulas in the cells. The normal method to do this would be:
-
open the File menu
-
go to Options, then Advanced
-
scroll down to Display Options for this Worksheet
-
check the box next to "Show formulas in cells instead of their calculated results," and uncheck the box to display results again.
However, there is also a convenient keyboard shortcut that does this much more quickly. The keystroke is Ctrl-~; press it once, and Excel displays formulas instead of results. Press it again, and the results appear again. As a bonus, when you use this tip to display formulas in cells, select a cell with a formula, and Excel outlines the cells that are referenced in the formula.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article