MrExcel Excel Videos

Episodes 801 and 815 suggested many ways for getting the total of 3 series in a stacked column chart to appear above the column. Both Ute and John wrote in with yet another method, a method that is probably the easiest. Episode 845 will show 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!

Today, a question about the Excel Watch Window. If you make changes to the format of a watched cell, why won't the format in the Watch Window change? Episode 864 shows you how to set up the watch window and how to get the latest formatting changes.

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.