How to Find Errors (#VALUE, #NAME, etc.) in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on November 26, 2022

This tutorial demonstrates how to find errors in Excel.


find errors initial data


Find Errors

In Excel, you may have the need to find errors and select them in order to delete or change their cells’ contents. This can be time-consuming to do manually if there are too many cells with errors. Consider the example pictured below, a list of values in Column B that includes various errors.


find errors initial data


To select cells with different kinds of errors (for this example, cells B3, B4, B7, and B10) at once, follow these steps:

  1. In the Ribbon, go to Home > Find & Select > Go To Special.


find errors go to special


  1. In the Go To Special window, select Formulas, check Errors (all the other options should be unchecked), and click OK.


find errors go to special 2


As a result, all cells that contain errors in a single sheet are selected.


find errors final data


See also

AI Formula Generator

Try for Free

See all How-To Articles