Pinterest Pixel

How to Show & Hide Formulas in Excel

When I have a sheet full of Excel formulas, sometimes I want to quickly check how each... read more

Download Excel Workbook
Bryan
Posted on

Overview

When I have a sheet full of Excel formulas, sometimes I want to quickly check how each formula looks like.  This is great for spreadsheet auditing.

It is very easy to do so in Excel!

Here is our sample worksheet with formulas:

How to Show & Hide Formulas in Excel

I explain how you can do this below:

How to Show & Hide Formulas in Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Press on your keyboard the following keys: Ctrl + `

The (`) key is usually located on the upper left part of your keyboard. This will show all your Excel formulas in your worksheet!

How to Show & Hide Formulas in Excel

Press the Ctrl + ` combination again to hide the formulas.

 

STEP 2: If you prefer to set this via Excel Options, another way is to go to File > Options

How to Show & Hide Formulas in Excel

 

STEP 3: Go to Advanced> Display Options for this Worksheet > Show formulas in cells instead of their calculated fields

Ensure this is checked.

How to Show & Hide Formulas in Excel

 

The formulas are all shown now too!  You can uncheck it to hide the formulas again.

See also  Getting the length of text with Excel's LEN Formula

How to Show & Hide Formulas in Excel

 

How to Show & Hide Formulas in Excel

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

How to Show & Hide Formulas in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!