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.


  1. Go to "Home" tab
  2. Click "Find & Select"
  3. Click "Go to Special..."
  4. Click "Formulas"
  5. Enable "Errors"
  6. Click ok!

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