How to Unlock Spreadsheets

by Kahlea Pendleton ; Updated September 28, 2017

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.

About the Author

Kahlea Pendleton has worked as a freelance editor since 2008. She has edited content for ChaCha.com a well-known, fast-moving texting company as an expeditor and has served as a homeschool teacher assistant for the past two years. She also has her degree in music education.

More Articles

Photo Credits