logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Select all cells with an error

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Select  ›  14. Select all cells with an error

This utility will select all cells on your worksheet with a formula that results in an error value.

Tip:
If you want to hide these errors, for example if you use a =VLOOKUP() formula, the following tool from ASAP Utilities can be useful: 'Custom formula error message'

Screenshots

Select  ›  14 Select all cells with an error

Starting this tool


Select  ›  14 Select all cells with an error
Select cells with the largest number



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


Empowering Excel Users Worldwide for 25 Years