everydayExcel Newsletter Header

Applying Selective Protection To Your Worksheet

Consider this scenario. You are working on the sales forecast for next year and would like to ask your sales team to estimate the amount of sales they are likely to achieve for next year. You have created a template that listed down all the information required for the forecast. Any change in the template by your sales people will hinder your effort in consolidation. However, when you activate the worksheet protection by going to menu -> Tools -> Protection -> Protect Sheet, the entire worksheet is protected. As a result, your sales people are not able to enter their sales forecast into the protected worksheet. You wonder how you could protect the worksheet such that your sales team can enter their sales forecasts into the selected cells without being able to modify the template...

Here's how: To protect the worksheet with only some ranges editable by your sales team, you need to unlock those cells first before you protect the worksheet. To find out how to do it, click on this protect worksheet page.

Protecting the worksheet is a good way to protect the layout of your template. But if your purpose of protecting the worksheet is to prevent your users from accessing the confidential information in hidden columns or rows, I would advise you to think twice. The protection on the worksheet is easily removed in three simple steps. In other words, all the confidential information within hidden rows and columns can easily become accessible to your users. We have actually demonstrated how this was done for our participants in one of our recent courses.

Our training course offers many valuable tips and tricks such as that illustrated above. We not only train what is available in Excel but also provide you with solutions to common Excel problems you encounter at work. If this is the type of Excel training you wish to attend, and experience an average 36% increase in productivity like our participants, sign up for our excel course now!

Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.

Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.

Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"


Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.