How to remove a password from an excel file

Written by greg lindberg
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel is a spreadsheet software application that allows you to enter data into the various cells in a workbook. You can then represent the data visually by creating a chart or graph that best suits your material. If you don't want other users to add, edit and delete data on your spreadsheet, then you can create a password to protect the workbook. You can later remove the password protection.

Skill level:
Easy

Other People Are Reading

Things you need

  • Microsoft Excel

Show MoreHide

Instructions

    Remove Password for Microsoft Excel 2003 Workbook

  1. 1

    Open the Microsoft Excel 2003 application on your computer and then click on the "File" option from the top toolbar menu. Click on the "Open" option.

  2. 2

    Locate the Excel 2003 file that includes the workbook for which you want to remove the password. Click on the file to highlight it and then click on the "Open" button.

  3. 3

    Click on the protected worksheet and then click on the "File" option from the top toolbar menu. Click on the "Save As" option.

  4. 4

    Click on the "Tools" menu and then click on the "General Options" button. Double-click on the asterisks next to the "Password to open" and "Password to modify" fields, and then press the "Delete" key on your keyboard.

  5. 5

    Click on the "OK" option and then click on the "Save" button. Click on the "Yes" option and the password will be removed.

    Remove Password for Microsoft Excel 2007 Workbook

  1. 1

    Open the Microsoft Excel 2007 application on your computer. Click on the "Microsoft Office" button and then click on the "Open" option.

  2. 2

    Locate the Excel 2007 file that contains the workbook that you want to unprotect. Select the file and click on the "Open" button.

  3. 3

    Click anywhere in the protected worksheet. Click on the "Review" tab and then click on the "Unprotect Sheet" option from the "Changes" group.

  4. 4

    Enter a password if you are prompted to and then click on the "OK" button. Your password will be removed, as the worksheet will no longer be protected.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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