Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Protect Worksheet In MS Excel 2007

Once we complete our work, we wish to protect our worksheet. Let us learn, how easily and quickly we can protect our worksheet. Consider a database for this as shown below: Let's say we want to protect column B and D from editing. Press ctrl key and select both the columns. Now press right click and click on “Format Cells” as shown below: As soon as we click on “Format cells” in the pop-up window that opens, under the “Protection” tab click on “Locked”. The locked option is enabled by default but it is preferable to uncheck it and check the box again. Cick on "OK". The locked option is applied to the selected columns. Right click on the sheet tab followed by clicking on “Protect sheet” and then click on "OK". In the "Protect Sheet" window that pops up, you are given various options to select the fields you wish to protect. Select your desired fields enter your “Password” in the space provided and click "OK". You will be notified to reenter your password. Enter the same password and click on "OK" once again. Followed this, column B & D will get protected and no one will be able to edit it till the time it is unprotected. In case some one tries to edit these two columns a message, as shown below, will pop up. In order to unprotect the worksheet you would need to right click on the sheet tab and click on “Unprotect sheet”. "Unprotect Sheet" window will pop up, where you will be prompted for your "Password". Enter your password and click "OK". Now your sheet is open for editing. In the example sheet, shown below, we edit the language for all the names to Chinese. So, that's how we protect our files and sensitive data from being edited by anyone. Tip: The option to protect worksheet is also available under the tab “Review” under “Changes”.

Post a Comment

Search Dummy Essentials Here:

Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits