From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Unlocking cells and protecting worksheets

Unlocking cells and protecting worksheets - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Unlocking cells and protecting worksheets

In Excel there are any numbers of protection schemes and one of the ones that gives you quite a variety of options is called Worksheet Protection. The actual sheet we're using right now is called WorksheetProtection; it's in the file called 11-Security&Ensuring. Let's imagine you're an HR manager, you've got a trusted assistant and what you do periodically handing that personal sheet of paper is a list of changes that need to be made to this list. One of the changes for example might be to change this Hire Date here to be 1998. Now you could imagine someone who doesn't know Excel way saying, okay, I'm going to make that 98, I'm going to make the years here be 15, so I'll go change the years to 15 and come over here and make this be 98. That's an innocent thought. However, this is a formula here, an unusual formula but nevertheless if you type a 15 there you've wiped out the formula. And so one security concern for sure is I want to protect my formulas. I don't want them destroyed. Now…

Contents