Episode 863 - WIIW - Protect Sheet

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.

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!

Episode 763 - Protecting Cells

When you use Tools, Protect Worksheet, all of the cells become protected. How can you protect only a portion of the worksheet? In Episode 763, we take a look at this problem and protect only the formulas in a worksheet.

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!