Google Sheets can make calculations a lot simpler with the help of equations and formulas. Use these steps to show equations in Google Sheets.
- Sign into Google Drive and open your Sheets file.
- Select the View tab at the top of the window.
- 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.
Step 3: Click the Show formulas option in the menu.
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.
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.
- How to change the orientation of a printed spreadsheet in Google Sheets
- How to sort a column from high to low in Google Sheets
- How to print with gridlines in Google Sheets
- How to copy multiple rows in Google Sheets
- How to change cell border color in Google Sheets
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.