MrExcel Excel Videos

Where is it Wednesday: Where did they move Tools, Protection, Protect Sheet? In Episode 863, I will show you how to protect only the formula cells in Excel 2007. While this was complicated in Excel 2003, it is just a bit more complicated in Excel 2007 when you can't find the final command, Protect Sheet.

Dan from Texas asks: is there a way to change the color of cells that are precedents of a particular formula. Use the technique in Episode 862 to quickly complete this task.

The subtotal command is a fantastic time-saver, but it occasionally behaves erratically. In Episode 861, I will show two situations which can cause the subtotal command to whack out.

Adding a company logo jpg to your worksheet header. Episode 860 shows how to add a header, and then poses a question about if your image is scaling in size as you add more data.

Its two-for-the-price-of-one-Thursday (sounds like we need a new theme...). Question 1: When editing a long formula, the formula covers up adjacent cells, making it difficult to point to those cells with the mouse. Question 2: When you use Shift Ctrl Right Ctrl Down to select a large range, the Error icon scrolls off the screen. I'll propose solutions to both of these in Episode 859.

In our Where Is it Wednesday podcast, we go looking for a command that most people never would have been able to find in Excel 2003! If you want to send a perfect copy of a formatted spreadsheet in an e-mail, you could use Snag-It or PrtScrn, but by holding down the shift key, you can find a hidden Copy as Picture command in Excel 2003. Episode 858 shows you how.

Say that you have a pivot table and need to send the file via e-mail. Use the trick in Episode 857 to dramatically reduce the size of your Excel workbook.

Is there any way to make Excel print 2 pages per physical sheet of paper? The answer is maybe...it all depends on your printer! Episode 856 shows you how.

Sergiy asks if there is any way to have a cell comment or a validation input box reflect a value from a formula in a cell. I couldn't find a good solution, other than using VBA. Episode 855 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!