How to Remove a Password Protected Cell

Excel is a spreadsheet program

Microsoft Excel is a powerful program that can be used like a very simple database or list of information or used to perform calculations and formulas from within one cell or between cells. One of the options in Excel is to protect spreadsheets and cells with a password so that the information does not get deleted by accident or changed in a way that the original author of the spreadsheet intended.

Things You'll Need

• Microsoft Excel

Instructions

1. Open Microsoft Excel. Open the Excel spreadsheet file from within Excel.

2. Find the security options in Excel. It will most likely be in the "Tool" menu under "Options." Look under the "General" tab and the "Security" tab if there is one. Look for password settings.

3. In the password protect field select the asterisks and then the delete button. There may be a second password field for modifications, if so delete that password as well. You may be required to enter the password before you can delete the old password.

4. Exit out of the menu choices. Select the cell that was password protected and then delete the cell.

References

• Henry Amon; Information Systems Specialist; Salisbury, Maryland
• Microsoft.com: Change or remove a workbook password