How to Unlock Spreadsheets

by Kahlea PendletonUpdated September 28, 2017
woman hands typing on laptop keyboard image by .shock from Fotolia.com

When you protect a worksheet in Microsoft Excel 2007 and 2010, all cells are locked and cannot be edited. To allow users to edit certain cells, you can unlock the cells within the document or enable specific users to edit specific ranges in a protected worksheet. Using a password to lock spreadsheets is optional. It is important to note, however, that if you do not want to add a password, then anyone can unprotect the spreadsheet and change the protected elements within your document. The steps to unlock a spreadsheet are the same for the 2007 and 2010 versions of Microsoft Excel.

Click on the "Start" button, and then click on "All Programs."

Click on "Microsoft Excel." The Microsoft Excel program will open.

Click on "Review," and then click on "Unprotected Sheet." You may be prompted to input your password if you used one to lock your spreadsheet.

More Articles