Discover new tools to get things done.
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!.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Tip:Alt+P for the previous tool.