Select All Cells Where Formulas Return an Error

ASAP Utilities › Select › 14. Select All Cells Where Formulas Return an Error

Quickly find and select all cells on your worksheet where a formula results in an error value.
This is useful for data quality control, helping you identify calculation issues and fix errors efficiently. It works with errors like #DIV/0!, #N/A, #VALUE!, #REF!, #NAME?, #NUM!, and #NULL!.

If you use this tool frequently, add it to your 'My Tools & Shortcuts' menu and assign a shortcut for faster access.

If some errors are unavoidable, use Excel's IFERROR() function to replace them with a more user-friendly message, or try our 'Replace Formula Errors with a Custom Message...' tool to have ASAP Utilities do that for you.

Screenshots

Select › 14 Select All Cells Where Formulas Return an Error

Starting this tool

Click ASAP Utilities › Select › 14. Select All Cells Where Formulas Return an Error
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
Find formula errors in Excel, Select cells with formula errors, Identify all formula errors in Excel, Locate cells where formulas return an error, Select all error cells, Find and highlight formula errors, Excel error checking tool for formulas, How do I select all cells with formula errors in Excel?, Is there a way to highlight all cells where formulas return an error?, Excel shortcut to find all cells with formula errors

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Select Cells Containing the Highest Value

Select All Sheets

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.