How to Put Excel & Google Sheets in Formula View Mode

This tutorial demonstrates how to put Excel and Google Sheets in Formula View mode.

 

 

Put Excel in Formula View Mode

In Excel, you can see the formula by selecting a cell. However, in some cases, it can be useful for you to see all the formulas in the worksheet. For example, if you want to change something in a formula when the formula view is enabled, you can use the Find option to change all formulas at once. Say you have the following example with formulas in Columns F and G (Price and Total Sales). In Column F, there is the VLOOKUP formula, while in Column G, the result is a multiplication of values from Columns E and F.

 

 

To enable formula view mode, in the Ribbon, go to Formulas > Show Formulas (or use the keyboard shortcut CTRL + ‘ ).

 

 

Now, formulas are displayed as text, and dates are shown as numbers.

 

 

Note: If you want to turn off the Formula View, and get back to the normal view, just follow the same path again and click Show Formulas.

Put Google Sheets in Formula Mode View

You can also show formulas in the sheet. In the Menu, go to View > Show Formulas (or use the keyboard shortcut CTRL + ‘ ).

 

 

As a result, all formulas in the sheet are displayed.