MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Highlight All Formula Cells

July 13, 2020 - by Bill Jelen

Excel Highlight All Formula Cells. Photo Credit: José Alejandro Cuffia at

If you are going to be auditing the worksheet, it would help to mark all of the formula cells. Here are the steps:

  1. Select any blank cell in the worksheet.
  2. Choose Home, Find & Select, Formulas.
  3. All of the formula cells will be selected. Mark them in a different font color, or, heck, use Home, Cell Styles, Calculation.

To mark all of the input cells, use Home, Find & Select, Go To Special, Constants. I prefer to then uncheck Text, Logical, and Errors, leaving only the numeric constants. Click OK in the Go To Special dialog.

Title Photo: José Alejandro Cuffia at

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.