How to Protect and Unprotect Sheets in Excel with Password?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
Sometimes it may be needed to protect the Excel sheets to prevent any further editing or accidental changes before giving it to clients or others who may want to just want to have access to view the contents and not edit it. This also helps to set a password to protect and allow certain users to edit and update the sheet.
So how to protect sheets and unprotect in Excel 2007 with password?
Go to the Review tab in Excel and Click Protect Sheet.
You will get a pop-up Protect Sheets. Check Protect Worksheet and contents of locked cells.
Set the password to unprotect sheet and check other options like select locked cells, select unlocked cells, format cells columns or rows, insert or delete rows, columns and others as desired.
Click ok. Now this sheet is protected.
To unprotect any protected sheets in Excel, go to Review tab and click Unprotect Sheet. Enter the password in the pop-up and now the sheet will be editable and unprotected.
Click here If you want to protect only certain cells in Excel. Also check the next post in the series, How to hide and unhide formulas in Excel?
This post is written for Excel from Office 2007.
[...] the last post we saw how to Protect and Unprotect Excel sheets with password in general and in this post for advanced users who want just to protect only certain cells, [...]
[...] we looked on how to protect Excel sheets with password and also selectively protecting certain cells, columns or rows in Excel. Hiding and unhiding [...]