- You can display formulas in Google Sheets with these simple tips
- Show formulas in Google Sheets with keyboard shortcuts
- Show all formulas in a worksheet
- Hide all formulas in a worksheet
- Enable Show Formulas
- Show individual cell formulas
- Hide formulas in Google Sheets with secure tables and ranges
You can display formulas in Google Sheets with these simple tips
Cells with formulas in Google Sheets display the answers to all formulas and functions on the sheet, not the formula or function itself.
In large spreadsheets, it can be difficult to find cells that contain formulas or functions.
Show formulas in Google Sheets with keyboard shortcuts
Take the guesswork out of when you need to display formulas in Google Sheets by using a simple keyboard shortcut to display all formulas in Google Sheets:
Ctrl + `
The keyboard key shown above is called the key serious accent † On most standard keyboards, the grave accent key is located to the left of the number 1 key. It resembles a backtick.
This keyboard shortcut works like a toggle in Google Sheets. This means that you press the same key combination again to hide the formulas when you are done viewing them.
Show all formulas in a worksheet
Press and hold a key ctrl on keyboard.
Press and release the button severe stress on the keyboard without releasing the key ctrl †
Release the key ctrl †
The worksheet shows all formulas in the cells that contain them, not the results of the formulas.
Hide all formulas in a worksheet
To redisplay the results for those cells, press the combination again ctrl † ††
When you display formulas in a Google sheet, it doesn’t change the contents of the sheet, just the way it is displayed. It is then easier to find cells with formulas. It also allows you to quickly read formulas to check for errors.
Enable Show Formulas
In addition to the above keyboard shortcut, you can also enable or disable the display of cell formulas on the entire sheet using the Google Sheets menu.
Click Vision on the menu.
Select Show formulas †
This is a good alternative if you prefer to use the Google Sheets menu instead of keyboard shortcuts.
Show individual cell formulas
Instead of viewing all the formulas in the entire spreadsheet, you can view the formulas one at a time in Google Sheets in one of two ways.
Double click on the cell with the formula
Left click once on the cell containing the formula, then press the key F9 on keyboard. A comment appears with the current result of the formula
Both actions give you an idea of the current results of the formula you enter.
Double-clicking the left mouse button on a cell also highlights the source cells, so you can see all the data in your spreadsheet that affects the formula’s results.
The F9 key allows you to see the results without exiting the cell editing mode.
When entering formulas into cells in Google Sheets, you can also press the key. to press F1 to see a comprehensive view of the formula will help you better understand how a particular formula works.
Hide formulas in Google Sheets with secure tables and ranges
Another way to hide formulas in Google Sheets is to use sheet protection, which prevents other users from editing formulas in locked cells.
The following steps will help you protect the entire range of cells so that no one can edit the formulas they contain.
Select the range of cells containing the formulas you want to hide.
Click Facts from the menu and select Protected plates and ranges †
In the pop-up window, select Set permissions †
In the dialog box, click Restrict who can edit this scope †
Remove all users you don’t want to edit cell formulas.
This process protects individual cells, a range of cells, or an entire worksheet.