How to Provide Protection of Important Documents Microsoft Excel

How to Provide Protection of Important Documents in Microsoft Excel - What is protection? According to the means of protection means protecting or securing. Well, in this case means is to protect an Excel worksheet can not be edited by anyone.

Excel is very vulnerable to edit those who are not responsible. Therefore, one of the measures to protect them is by giving a password on the Excel worksheet that can not be edited by anyone.

So suppose you have important documents on a worksheet excel, it is necessary once this protection. Suppose you have a data value and ranking students such as the following in your Excel worksheet.

 

So how? Let's see the steps below.

 
Protecting Worksheet

 
1. So that can not be edited, deleted or copied, put your mouse pointer to the Review menu tab and select / click Protect Sheet menu.

 

2. If you already click Protect Sheet will display a new dialog box tick Protect worksheet that contains an contents of locked cells. You should check that the contents to activate the protection.

3. If necessary give the password in the "Password to unprotect sheet" to open the worksheet protection, for example the password is 123456789 as in the image below.

 

4. The next section is the Allow all users of this worksheet to, which is used to allow other users to modify a limited basis in accordance permission that you can select via tick. Tick ​​on:

•  "Select locked cells" to allow other users perform select a locked cell
• "Select unlocked cells" to allow other users do not select locked cells 
•  "Format cells" to allow other users to modify cell formats 
•  "Format rows" to allow other users to modify the format of the line
• "Format columns" to allow other users to modify the format of the column 
• "Delete columns" to allow other users perform delete / remove columns
• "Delete Rows" to allow other users perform delete / remove the line

5. If it is then it will pop up a dialog box that asks you to confirm your password. Enter again passwdord 123456789 and click OK on this dialog box, and finished

 

Trials and How to Unlock Protection

 
Try to edit or copy, certainly can not. Then how to unlock the protection that we can edit it again? Easy, go to the Review tab, click Unprotect sheet. A pop-up window will appear as below, and you just enter the password you created earlier when creating protection (123456789), and then click OK.

 
Now that's a tutorial on how to give protection to a worksheet Microsoft Office Excel 2007 as well as ways to reopen protection. We wish to provide this protection Excel document you be more secure than the things we do not want. Finally, good luck