# How to Put Excel & Google Sheets in Formula View Mode

Written by

Reviewed by

*This tutorial demonstrates how to put Excel and Google Sheets in formula view mode.*

### Formula View Mode Shortcut

This Excel shortcut toggles Formula View mode on and off.

## Put Excel in Formula View Mode

In Excel, you can view a formula by selecting the cell it’s in. 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 Find & Replace 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 a 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 serial 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 on the sheet.

▸ In the **Menu**, go to **View > Show Formulas** (or use **CTRL + `**).

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