Pinterest Pixel

Highlight All Excel Formula Cells

  Whenever you are auditing an Excel worksheet and need to know where all the formulas are... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Highlight All Excel Formula Cells | MyExcelOnline Highlight All Excel Formula Cells | MyExcelOnline

 

Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done:

STEP 1: Select all the cells in your Excel worksheet by clicking on the top left hand corner of your worksheet.

Highlight All Excel Formula Cells

 

STEP 2: Press the CTRL+G shortcut which will open up the Go To dialogue box and select the Special button.

Highlight All Excel Formula Cells

 

STEP 3: Select the Formula radio button and press OK.

Highlight All Excel Formula Cells

 

STEP 4: This will highlight all the formulas in your Excel worksheet and you can use the Fill Color to color in the formula cells.

Highlight All Excel Formula Cells

And now all your cells containing formulas are now highlighted!

Highlight All Excel Formula Cells

You can practice this cool trick by downloading this workbook:

Highlight All Excel Formula Cells | MyExcelOnline

Download excel workbookHighlight-all-Formula-Cells.xlsx

Further Learning:

See also  Use Excel Goal Seek To Find The Formula Result You Want

 

 

 

If you like this Excel tip, please share it
Highlight All Excel Formula Cells | MyExcelOnline Highlight All Excel Formula Cells | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

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!

Share to...