Step By Step For How To Protect Worksheet And Cells In Microsoft In Excel 2007

To prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can protect certain worksheet in Microsoft Excel with password. Some new users in Excel sometime still confuse for how to protect sheets and cells. Follow step by step below for how to protect sheets and cells in Excel.

For Example: You want your user only can fill/ type text in the yellow background cells (cannot type outside yellow beck ground cells).



1. Select the cells that you want to protect (the yellow background cells).
Computer Tips: Hold down CTRL key on your keyboard if you want to select another cell

2. On the Home tab, in the Cells group, click Format, and then click Format Cells



3. On the Protection tab, clear the Locked check box, and then click OK.



4. On the Review tab, in the Changes group, click Protect Sheet.



5. In the Password to unprotect sheet box, type a password for the sheet, click OK, and then retype the password to confirm it.



6. Done

If you want to Remove the protection, simply, On the Review tab, in the Changes group, click Unprotect Sheet and type your Password.

Related Topics:
How to configure Word, Excel 2007 options to save file into 97-2003 format?
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Step By Step For How To Protect Worksheet And Cells In Microsoft In Excel 2007
How to find Duplicate entries in Microsoft Excel 2007
Easy tips to delete blank rows in Excel
Easy tips to create graphic in Excel
Microsoft Excel 2007: How to take limit value to the cell