Formula Friday – Easily Spot Excel Formula Errors In A Large Excel Worksheet


 

It’s Friday yet again, time for some Formula Fun…..Let’s take a look at finding formula errors today.  If you have a really large worksheet you may not be able to look at it all at once and be confident you have no errors in your formulas.  Here is an easy way to quickly identify all of your formulas are working as they should and have no obvious problems.

  • Home Tab
  • Find and Select (or hit F5 keyboard shortcut to get you to the same dialog box)
  • In the Go To Special Dialog Box Select Formulas
  • Select Errors
  • Hit Ok

 

find errors

 

Any Errors will be highlighted in your Excel worksheet.

find errors1

  • Once all your cells are highlighted with formula errors, you can format them to stand out
  • Hit Home Tab – Font – Fill Colour
  • Choose a colour to indicate an error in my example I have chosen Yellow

 

 

find errors2find errors3

 

Easy as that, if you have errors spread across your large worksheet, taking the extr step to format them in some way to make them stnd out really helps.

More Excel Tips

 

 

excel-formulas-ad-5

 

receommended books

[amazonjs asin=”1118490444″ locale=”US” tmpl=”Small” title=”Excel 2013 Formulas”]

[amazonjs asin=”1118460847″ locale=”US” tmpl=”Small” title=”Excel Formulas and Functions For Dummies”]

[amazonjs asin=”1118902688″ locale=”US” tmpl=”Small” title=”101 Ready-to-Use Excel Formulas (Mr. Spreadsheet’s Bookshelf)”]

Read My Review Of Chandoo’s VLOOKUP Book Here

the-vlookup-book-ebook-combo

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts