MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Highlight All Formula Cells


July 10, 2019 - by Bill Jelen

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

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 Unsplash.com


Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.