How to Password Protect a Microsoft Excel Spreadsheet

PDF download Download Article
A quick guide to putting a required password on a file in Microsoft Excel
PDF download Download Article

Do you have an important Excel file you want to protect? You can easily lock your Excel workbook with a password. For even more safety, you can set the spreadsheet as "Read Only". This prevents accidental editing from any viewers. Be sure to use a password you can remember, as you won't be able to reset it. This wikiHow will show you how to password-protect a file in Microsoft Excel using your Windows or Mac computer.

Things You Should Know

  • Click "File" → "Info" → "Protect Workbook" → "Encrypt with Password". Enter a password twice and click "OK".
  • To set as Read-Only, click "File" → "Info" → "Protect Workbook" → "Always Open Read-Only".
  • Be sure to use a password you can remember; you won't be able to reset it if you forget.
Method 1
Method 1 of 2:

Using Office 365/Excel 2016, 2013, 2010

PDF download Download Article
  1. If needed, you can create a new spreadsheet . [1]
  2. This will be at the top-left corner of the window, next to Home .
    • A new page will open.
    Advertisement
  3. You can find this in the left panel.
  4. This is the first tile of the Info tab.
    • A drop-down menu will open.
  5. If you want to prevent accidental changes from others when you share your workbook , you can set the workbook as "Read-Only". Keep in mind that others will be able to change this mode if they choose.
    • Click Always Open Read-Only in the drop-down menu.
    • You'll see an icon of a pencil and cancel symbol underneath Protect Workbook .
  6. This will be below Always Open Read-Only .
    • A pop-up box will open.
  7. Keep in mind you won't be able to reset or recover the password if you forget it. Be sure to use a password you can remember .
  8. Input the same password as the previous step.
    • You should now see a lock and key icon underneath Protect Workbook .
  9. If you're prompted to save, be sure to save. When you open the workbook again, you'll be asked to enter in your password.
    10. Advertisement
Method 2
Method 2 of 2:

Using Excel 2007

PDF download Download Article
  1. If needed, you can create a new one.
  2. This is the tab at the top, next to Data .
  3. This is in the "Changes" section.
  4. If you have also set up specific windows within the file, check the pertinent box as well.
  5. Be sure to use a password you can remember, as you won't be able to reset it. You may need to do this twice.
  6. Your Excel file is now password-protected. When you open it, you'll be asked to input your password.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    I have made a sheet in Excel which contains 2000 names and addresses, so now I want to make this sequenced. First a, then after that b, c, etc. How do I do this?
    Sylvia Saltaformajo
    Community Answer
    Right-click on the column you want to sort your sheet by. A menu will open. Hover over the "Sort" option in it. You will see another menu, click "Sort A to Z" in it.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 2
  • Question
    What do I do if I forgot the password?
    Sylvia Saltaformajo
    Community Answer
    Unfortunately you can't recover forgotten passwords for MS Excel spreadsheets. You'll have to recreate a document or recover password using special software. You can find it online, there are many options: Password-Find, Password Lastic, Rixler password recovery, etc.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 0 Helpful 5
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      Warnings

      • Password protecting your Excel sheet will keep the average user from messing around in your files, but a determined user can purchase password-cracking software to view your sheets.
        Thanks
        Helpful 0 Not Helpful 0
      Advertisement

      You Might Also Like

      Easy AutoFilter Basics for Beginners
      How to
      Unshare an Excel Workbook on Desktop & Mobile
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Link Sheets in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/protect-an-excel-file-7359d4ae-7213-4ac2-b058-f75e9311b599

      About This Article

      Article Summary X

      1. Open the file.
      2. Click File .
      3. Click Protect Workbook .
      4. Click Encrypt with Password .
      5. Enter a password.
      6. Click OK .
      7. Close the document.
      8. Reopen and enter the password.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 333,620 times.

      Reader Success Stories

      • Ningappa Totigara

        Mar 31, 2018

        "How to protect a workbook or worksheet."
        Rated this article:
      Share your story

      Is this article up to date?

      Advertisement