Google Sheets Tip: Show Formulas in Google Sheets

If you have lots of formulas in your Google Sheets spreadsheet, it can be very useful to see all the formulas in the spreadsheet at once.

To show formulas in a Google Sheets spreadsheet, select View —> Show → Formulas.

All of the formulas in the spreadsheet will be displayed at once in the formulas view.

You can go back to seeing values by unselecting Formulas from the View → Show menu.

You can also use the CTRL + ` keyboard shortcut to toggle between showing formulas and showing values.

Here is a video that demonstrates how to show formulas in Google Sheets spreadsheet:

Thanks for reading!