How to Secure Excel File

The right way to secure an Excel file depends on what you need to stop.

Do you want a password before anyone can open the workbook? Do you want people to open it but prevent changes to a sheet? Or do you only need to stop someone from adding, deleting, or moving worksheets?

Excel has separate tools for these jobs. Choosing the wrong one can leave your personal or business information more open than you expected.

Choose the type of Excel protection you need

Use this quick decision tree:

1. Need a password before the file can be opened?

Use File > Info > Protect Workbook > Encrypt with Password.

1. Need to protect the workbook itself?

Use Protect Workbook from the Review tab.

1. Need to protect cells or a worksheet from changes?

Use Protect Sheet from the Review tab.

These choices are related, but they don't do the same thing.

Encrypt with Password controls access to the file. A person must enter the password before the workbook opens.

Protect Workbook and Protect Sheet control what someone can do after the workbook is open. They are for workbook or worksheet protection, such as limiting changes to the file's structure or to cells on a sheet.

That difference matters. A protected sheet may still be visible. A workbook with an opening password can't be viewed until the password is entered.

Password-protect an Excel file so it requires a password to open

If the file contains names, addresses, household records, payment details, customer information, or other private data, the opening-password option is the one to look at first.

The documented Excel workflow is:

1. Open the Excel workbook.
2. Select File.
3. Select Info.
4. Select Protect Workbook.
5. Choose Encrypt with Password.
6. Enter a password in the Password box.
7. Select OK.
8. Follow the prompt to enter the password again if Excel asks you to confirm it.
9. Save the workbook.

Close the file after saving, then open it again. Excel should ask for the password before showing the workbook.

This is the answer to how to secure Excel file with password when you want to control who can open it. It also lets you restrict access to an Excel file, rather than only restricting what people can change.

Choose a password you can keep safe

Don't use a password that other people can easily guess from the file or from your household. For example, avoid using a child's name, a pet's name, a company name, or a date shown in the workbook.

Most of all, don't lose the password. The supplied Excel guidance does not provide a password recovery method. If you forget it, you may not be able to open the protected workbook.

Keep the password separate from the file. Anyone who has both the file and its password can open it.

Protect a workbook or worksheet from the Review tab

The Review tab contains two separate choices:

• Protect Workbook
• Protect Sheet

Pick the one that matches the part of the file you want to control.

Use Protect Workbook for workbook-level changes

Choose Protect Workbook when your concern is the workbook as a whole. This is about the workbook's structure and how its worksheets can be handled after the file is open.

For example, you might want to stop someone from changing the workbook setup while still allowing them to open and read it.

To use it:

1. Open the workbook.
2. Select the Review tab.
3. Select Protect Workbook.
4. Follow the prompts shown by Excel.
5. Save the workbook.

The exact prompt can depend on the Excel version and the protection settings available in that version. The key point is that this is workbook protection, not the same as putting a password in front of the entire file.

Use Protect Sheet for worksheet changes

Choose Protect Sheet when you want to control changes on a particular worksheet.

This can be useful if a workbook has:

• A household budget that others should view but not alter
• A business form that customers or staff should fill in carefully
• A list where certain cells contain formulas
• A shared record where some cells should remain unchanged

To use it:

1. Open the workbook.
2. Select the worksheet you want to protect.
3. Select the Review tab.
4. Select Protect Sheet.
5. Follow the prompts shown by Excel.
6. Save the workbook.

Protecting one sheet doesn't automatically mean every sheet in the workbook is protected. If the file has several worksheets, check each one that contains information you need to keep from being changed.

Restrict editing, copying, or changes without confusing it with encryption

People often ask how to protect Excel sheet from editing and copying. Excel's protection tools can limit changes, but you should separate three different goals:

• Stopping the file from opening: use Encrypt with Password.
• Stopping worksheet changes: use Protect Sheet.
• Stopping workbook structure changes: use Protect Workbook.

A sheet that is protected from editing may still be visible to someone who can open the workbook. So worksheet protection isn't a replacement for an opening password when the information itself is private.

Likewise, workbook protection isn't the same as encryption. It controls selected workbook actions after the file has been opened. It doesn't answer the question, “Can this person view the workbook at all?”

If your main concern is copying information, think about what the person can see once the file is open. A protection setting aimed at editing doesn't automatically make visible information private. If someone is allowed to open the workbook, you should assume they can view the parts of it that remain available to them.

For sensitive information, start with the opening-password workflow. Then add sheet or workbook protection if you also need to limit changes.

Check that the password protection works before sharing

Don't assume the file is protected just because you clicked a menu option. Test it.

Check an opening password

1. Save the workbook after setting the password.
2. Close Excel or close the workbook.
3. Open the file again.
4. Confirm that Excel asks for the password before showing the workbook.
5. Enter the password and make sure the file opens normally.

If the file opens without asking for a password, you used a different protection setting or the change wasn't saved.

Check worksheet or workbook protection

With the file open, try the type of action you want to restrict. For example, check whether a protected sheet still allows an unwanted edit, or whether a workbook-level change is blocked.

Also check every relevant worksheet. One unprotected sheet can contain information that the other settings don't cover.

Test before sharing with a parent, carer, customer, colleague, or gift recipient. It is much easier to fix a protection setting while you still have your own working copy.

Keep an unprotected backup only if you can store it safely. An unprotected copy can defeat the care you took with the shared version.

How to securely send a password-protected Excel file

Password-protecting the workbook controls access to the file. It does not explain how the file travels from you to another person.

The supplied Excel instructions show how to require a password before opening the workbook, but they don't specify a file-transfer service or method. So don't treat the opening password as a guarantee that email or another sharing method is secure.

Before sending the file:

1. Set the opening password with File > Info > Protect Workbook > Encrypt with Password.
2. Save and close the workbook.
3. Reopen it to check that the password prompt appears.
4. Send the protected file using the sharing method you normally trust for the type of information involved.
5. Share the password separately from the file when possible.
6. Tell the recipient which password belongs to the workbook.

Don't put the password in the same message as the file if you can avoid it. If the file and password are delivered together, anyone who gets that message may have everything needed to open the workbook.

Also, send only the copy that needs to be shared. Check the workbook first for extra worksheets, old information, or private details that the recipient doesn't need.

How to remove a password or unencrypt an Excel file

You may need to remove protection when a file is no longer private, when several people need access, or when you are replacing an old password.

Remove the password required to open the file

If you know the current password and can open the workbook:

1. Open the workbook.
2. Select File.
3. Select Info.
4. Select Protect Workbook.
5. Choose Encrypt with Password.
6. Remove the password from the Password box.
7. Select OK.
8. Save the workbook.

Close it and open it again to check that Excel no longer asks for the opening password.

This is what people usually mean by how to unencrypt an Excel file in this situation: remove the password requirement from the workbook using the same protection area. Make sure you have the right file before removing protection. Keep a protected copy if you may need it later.

Remove worksheet or workbook protection

For protection added from the Review tab, return to the same area in the open workbook. Excel may show an option such as Unprotect Sheet or an option to turn off workbook protection, depending on which protection you applied and which Excel version you use.

Follow the prompt and enter the protection password if Excel requests it. Save the file after the protection is removed.

Removing a sheet's protection doesn't remove an opening password. These are separate settings. If the file still asks for a password when you open it, use the File > Info > Protect Workbook > Encrypt with Password route described above.

Excel password protection questions for Windows 10, Windows 11, and older versions

Is there a way to secure an Excel workbook?

Yes. You have two main routes:

• Use File > Info > Protect Workbook > Encrypt with Password to require a password before the workbook opens.
• Use Protect Workbook or Protect Sheet from the Review tab to limit workbook or worksheet changes.

Choose based on whether you need to control access or control editing.

How do I put password protection on an Excel file?

Select File, then Info, then Protect Workbook, and choose Encrypt with Password. Enter the password in the Password box, select OK, and confirm it if Excel asks you to do so. Save the file, close it, and reopen it to test the password prompt.

Can I password-protect an Excel sheet from viewing?

If you need to stop someone from viewing the workbook at all, protect the file with an opening password using Encrypt with Password.

Protect Sheet is for restricting changes to a worksheet after the workbook has been opened. It shouldn't be treated as the same thing as hiding the workbook behind a password.

Does Excel protection work differently on Windows 10 and Windows 11?

The basic protection choices described here are the same ones to look for in Excel: File > Info > Protect Workbook > Encrypt with Password, plus Protect Workbook and Protect Sheet on the Review tab.

The wording or layout can vary between Excel versions, including older versions. If you don't see an option in the same place, look for the Review tab for sheet and workbook controls, and the Info area under File for file protection.

What should I do if I forget the password?

Don't remove the password until you have a working copy and a safe record of the new access details. The supplied guidance does not give a recovery method, so don't assume a forgotten password can be recovered.

Before sharing, check which protection you need: a password to open the file, workbook protection, or sheet protection. Then test that exact setting. For more plain-language help with practical digital and family tasks, explore Baby Sock Shoe's other guides.