Tip of the Day | Sunday 26 July 2026

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.

Starting this tool