Using the Go To Special Command in Excel 2007 to Spot Formula Errors

The “Go To Special” Commands is one of my favorites. And, Excel 2007 places it in a prominent position on the Home Tab of the Ribbon.

I use Go To Special to quickly highlight all of the cells that contain Formulas. This way I can see if someone has accidentally “hard-coded” a Constant Value in a cell that should contain a Formula.

In this short video lesson I also show you another way that I use Go To Special – to reuse a Budget Worksheet or a worksheet for Expense Account Reports.

I you enjoy this tip and my style of training, I invite you to visit my online bookstore. It is a secure shopping site where I sell my “The 50 Best Tips for Excel 2007” DVD as well as DVD s for PowerPoint 2007, Outlook¬† 2007, ¬†and Word 2007.

Click here to watch this Excel Video Lesson on YouTube.

Related Excel Videos:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. I’m havin’ some troubles trying 2 load your weblog. I have been read it(blog) many times before and never gotten something like this, but now when I try 2 load something it just takes a little while (1-11 minutes) & then just stop. I have tried with www or not. Does anyone know what the problem could be? Please ask your support guy at hosting..And, yes, thanks for your blog!

Speak Your Mind