• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Protecting Excel Worksheets (from yourself and others)

by on
in The Office Tech Pro

If you’ve ever worked for hours on a workbook one day, then destroyed it with a few poorly planned changes the next, you’ll appreciate these tips on how to protect your work with cell locking, worksheet and workbook protection.

Cell Locking with Worksheet Protection – If I told you that ever cell in a worksheet was already locked, you’d probably question my grasp on reality. But, indeed, they are. Click the cornerstone of the worksheet to select all cells. On the Home tab, in the Cells group, click the Format drop-down button. You’ll notice that there is an orange box around the Lock Cell selection. What this means is that the locks on the selected cells are ready to be activated. On that same drop-down menu, if you choose Protect Sheet and click OK, the locks are now active and you will not be able to type in any locked cell. Now that you know how it works, click Unprotect Sheet. It’s on the same menu. Turn off the lock attribute on any cells you want to be able to type in, then select Protect Sheet. Now, you won’t be able to delete those technically elegant, 9 ½ foot IF statements!

Microsoft Excel


Workbook Protection - If you’ve hidden worksheets or your formulas depend upon them being in a particular order, you can also turn on Workbook protection. On the Review tab, in the Changes group, click the Protect Workbook button. You’ll notice the Structure checkbox is already checked. Leave this default and click OK. Now any hidden worksheets will remain hidden, and the structure and order of the worksheets cannot be altered.

Microsoft Excel

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/36019/protecting-excel-worksheets-from-yourself-and-others "

Leave a Comment