How to Show Formulas in Google Sheets

The beauty of formulas in spreadsheets is their ability to perform calculations for you. Often this occurs with the help of a mathematical operator in combination with a cell location.

In most cases, the most important part of this scenario is the value that the formula produces, but you might find yourself needing to know a bunch of formulas in a spreadsheet.

You can click on the cell to see the formula, but if you need to see a lot of formulas at once, then you might prefer something that is a little more helpful.

Fortunately, Google Sheets allows you to toggle between the display of the formula value and the formula itself. Our guide below will show you where to find this option so that you can use it when needed.

Display Formulas Instead of Values in Google Sheets

The steps in this article will change a setting in Google Sheets so that your formulas are shown instead of the values that those formulas produce. Note that this applies to every formula in the spreadsheet. You can follow these same steps to stop showing formulas and show the values again.

Step 1: Go to your Google Drive at and open the file containing the formulas that you would like to display.

Step 2: Click the View tab at the top of the window.

click the view tab in google sheets

Step 3: Click the Show Formulas button. Note that you can also show the formulas in your spreadsheet by pressing the Ctrl + ` keys at any time. Note that the ` key is the one above the Tab key on your keyboard. It is not the apostrophe key.

how to show formulas in google sheets

Do you need to submit a spreadsheet in the Microsoft Excel file format, but you only have access to Google Sheets? Learn how to export to Excel from Google Sheets and create the file type that you need.

Microsoft Excel is another great application for working with formulas. Our tutorial on how to subtract in Excel can show you how to use that formula in the Microsoft spreadsheet application.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy