logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Monday December 1st, 2025

Tip of the Day | Monday December 1st, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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  ›  Select All Cells Where Formulas Return an Error

    Starting this tool


    Select  ›  Select All Cells Where Formulas Return an Error

    Choose your language preference below

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

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 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.