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:
- Visit My Excel Video Lesson Index – to find a specific video lesson
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!