This post shows you how to visualize all formulas on an Excel sheet at once.
To see all formulas on a worksheet, go to Formulas > Show Formulas or simply use the shortcut ctrl + ~
Following are detailed instructions:
I have an income statement with many formulas that looks like the following:
Most of these number are derived by formulas. I want to quickly inspect all the formulas. To do so I click on Forumlas > Show Formulas:
To switch back, simply unclick Show Formulas.
You can also use ctrl+~ to turn this feature on and off.