How to unprotect an Excel Workbook with no password

Written by james andrews Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to unprotect an Excel Workbook with no password
Microsoft Excel workbooks can be password protected to prevent access by unauthorised users. (Courtesy of Microsoft)

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:


  1. 1

    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.

  2. 2

    Open the specific workbook you wish to remove the protection from and navigate to the "Tools" menu at the top of the screen.

  3. 3

    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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.