Best-selling spreadsheet program Microsoft Excel allows you to create documents and restrict access to them to prevent confidential or private information from falling into the wrong hands. Once a workbook is given a password, only people who know that password can open and edit the data it contains. Depending on the nature and sensitivity of the information, the workbook may not have a password but simply be "protected" to prevent anyone from accidentally editing or deleting the information.
- Skill level:
Other People Are Reading
Open Microsoft Excel by clicking on the program's green and white icon on your computer's desktop menu. Alternatively, select the "All Programs" option that is accessed by clicking the Microsoft Windows icon in your toolbar and then choose Microsoft Excel.
Open the specific workbook you wish to remove the protection from and navigate to the "Tools" menu at the top of the screen.
Click on "Protection," and select and click on "Unprotect Workbook" from the list of options. The protection has now been removed and you can edit, copy, delete or expand the data without restriction.
Tips and warnings
- Even if no-one else normally uses your computer you should consider using passwords and protecting Microsoft Excel workbooks and worksheets in case someone steals your PC or laptop.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for