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

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