How to see all formulas in Excel sheet

Sometimes you may need to see all formulas in different Cells in an Excel worksheet. If you want to to see all formulas in different Cells in an Excel worksheet, press "Ctrl" and "~" (tilde) keys together.

You can see that all the formulas in Excel worksheet is visible, as shown below.

To hide all formulas and go back to normal, again press "Ctrl" and "~" (tilde) keys together.