See all How-To Articles

How to Put Excel & Google Sheets in Formula View Mode

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

 

enable formulas view 2

 

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.

 

formula view mode initial data

 

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

 

enable formulas view

 

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

 

enable formulas view 2

 

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 + ‘ ).

 

google sheets show formulas

 

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

 

google sheets show formulas final