Author: Oscar Cronquist Article last updated on August 07, 2018

Excel has great built-in features. The following one lets you search an entire worksheet for formulas that return an error.

Instructions:

  1. Go to "Home" tab
  2. Press with left mouse button on "Find & Select"
  3. Press with left mouse button on "Go to Special..."
  4. Press with left mouse button on "Formulas"
  5. Enable "Errors"
  6. Press with left mouse button on ok!

If any formulas errors exist, they are now selected. The picture below demonstrates error cells being selected.