How to Show Equations in Google Sheets

Google Sheets can make calculations a lot simpler with the help of equations and formulas. Use these steps to show equations in Google Sheets.

  1. Sign into Google Drive and open your Sheets file.
  2. Select the View tab at the top of the window.
  3. Choose the Show Formulas option.

This article continues below with additional information and pictures for these steps.

Often when you are looking at data in a spreadsheet you are only seeing the results of work that is being performed behind the scenes.

Spreadsheet applications like Google Sheets can be very powerful, and many users employ equations, or formulas, to calculate the results that you see in the cells.

But you may be wondering what formula someone used to arrive at a displayed value, so you might be interested in seeing that formula.

While you can click on a cell that contains a formula to see it in the formula bar, you can also toggle a switch that lets you see all of the equations in the cells.

Our guide below will show you how to show equations in Google Sheets.

How to View Equations in Google Sheets

The steps in this guide were performed in the desktop version of the Google Chrome Web browser, but will work in other desktop browsers, like Firefox or Edge, as well.

Step 1: Sign into Google Drive and open your Google Sheets spreadsheet.

Step 2: Select the View tab in the toolbar at the top of the window.

click the View tab

Step 3: Click the Show formulas option in the menu.

how to show equations in Google Sheets

You should now see the cells with formulas switch over so that the equations are displayed as well. I have chosen to show equations in the image below.

example of equations shown in Google Sheets

Note that you can also use the keyboard shortcut of Ctrl + ` to switch between viewing the equations and the results of those equations. The character in that shortcut is the accent key, which is above the left Tab key on most keyboards.

Additional Reading