Google Sheets Tip: Show Formulas in Google Sheets

Last updated: February 09, 2025

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!

DISCLAIMER: This content is provided for educational purposes only. All code, templates, and information should be thoroughly reviewed and tested before use. Use at your own risk. Full Terms of Service apply.

Small Scripts, Big Impact

Join 1,500+ professionals who are supercharging their productivity with Google Sheets automation

Exclusive Google Sheets automation tutorials and hands-on exercises
Ready-to-use scripts and templates that transform hours of manual work into seconds
Email updates with new automation tips and time-saving workflows

By subscribing, you agree to our Privacy Policy and Terms of Service