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.

Screenshot of a Google Sheets spreadsheet that shows the View menu open and the Show formulas menu item selected.

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

Screenshot of a Google Sheets spreadsheet where formulas are shown.

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

Screenshot of a Google Sheets spreadsheet where values are shown.

You can also use the following keyboard shortcuts to toggle between showing formulas and showing values.

  • On chromebooks or Windows: CTRL + ~

  • On Mac: ⌘ + ~

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

Thanks for reading!

Master Google Sheets Automation

Sign up to receive exclusive Automation tips and tutorials!
I'll send you actionable tips on automating tasks with Google Sheets and coding with Apps Script. You'll also be notified whenever new content is published.
PLUS: Get instant access to my Birthday Reminder Template! 🎂
By signing up you agree to the Privacy Policy & Terms.
Have feedback for me?

I'd appreciate any feedback you can give me regarding this post.

Was it useful? Are there any errors or was something confusing? Would you like me to write a post about a related topic? Any other feedback is also welcome. Thank you so much!