Can You Password Protect One Sheet in Excel? Here’s How

How-to basics · Updated November 18, 2026

Yes. In Excel for Microsoft 365 on Windows, select the worksheet, choose Review > Protect Sheet, enter an optional password, choose what users are allowed to do, and select OK. This protects that sheet from selected edits; it does not encrypt the workbook or prevent someone from viewing its contents.

What protecting one worksheet actually does

Excel lets you protect an individual worksheet without applying the same editing restrictions to every other sheet in the workbook. For example, you could protect a sheet containing calculated results while leaving an Instructions sheet editable. You can also use different passwords for different sheets, or protect a sheet without setting a password at all.

Worksheet protection works with each cell’s Locked setting. In a new worksheet, cells are generally marked as locked by default, but that setting does not restrict editing until you turn on sheet protection. After protection is enabled, Excel blocks changes to locked cells and allows the actions you permit in the Protect Sheet options.

This makes the feature useful for preventing accidental edits to formulas, labels, or a carefully arranged form. It is not a secure way to keep confidential information private: a person who can open the workbook can generally see the sheet’s contents, and protection is not the same as file encryption.

How to password protect one sheet in Excel

Use the desktop Excel app for Microsoft 365 on Windows for the clearest set of controls. The password is optional, but without one, someone can turn off protection without entering a password.

  1. Open the workbook and select the sheet tab you want to protect. Check the sheet name before continuing; this command applies to the active worksheet.
  2. Open the Review tab and select Protect Sheet.
  3. In the Protect Sheet dialog box, enter a password if you want users to need it to remove protection.
  4. Review the list of allowed actions. For example, leave Select locked cells and Select unlocked cells checked if users should be able to move around the sheet and fill in designated input cells.
  5. Select OK. If you entered a password, Excel asks you to enter it again to confirm.
  6. Try editing a cell that should be protected, and try editing an input cell if you have created one. This confirms that the restrictions match your intended use.

To remove protection later, select the protected sheet, go to Review > Unprotect Sheet, and enter the password if Excel asks for it. Removing sheet protection does not delete the worksheet or its data; it restores the ability to edit cells according to their Locked settings.

Let users edit only selected cells

A common setup is to protect formulas while leaving a few cells open for data entry. First, select the cells people should be able to change. To select several separate areas, hold Ctrl while selecting them. Open the Format Cells dialog with Ctrl+1, select the Protection tab, clear the Locked check box, and select OK. Then protect the worksheet using Review > Protect Sheet.

With the sheet protected, the unlocked cells remain editable while locked cells are restricted. For instance, a simple expense template could leave cells for date, category, and amount unlocked, while keeping total formulas and instructions locked. The protection dialog can allow users to select unlocked cells while preventing them from selecting locked ones, which can make a form easier to use.

You can also mark formulas as hidden in Format Cells > Protection. The formula is concealed in the formula bar only when the worksheet is protected. This can reduce casual exposure of a formula, but it does not make the workbook a safe place for secrets or proprietary information. Anyone with access to the workbook may still be able to inspect or copy its visible results.

Choose the actions people can still perform

The Protect Sheet dialog is more flexible than a simple edit/no-edit switch. Depending on the worksheet and your needs, you can allow selected actions while keeping locked cells protected. Options include selecting locked or unlocked cells, formatting cells, columns, or rows, inserting or deleting rows and columns, sorting, using AutoFilter, and using PivotTable reports.

Allow only the actions that are necessary. If people need to filter a table, for example, enable Use AutoFilter. If they need to sort data, allow Sort as well. Do not assume that enabling one option automatically enables related ones; test the protected sheet with the actions your users will need. Some actions may also be limited when they would affect protected cells.

To protect the layout of the workbook itself, use the separate workbook-structure protection feature. Sheet protection controls actions on a particular worksheet. Workbook structure protection can restrict actions such as adding, deleting, moving, hiding, or renaming sheets. It does not replace worksheet protection, and neither feature encrypts the workbook’s contents.

Sheet protection versus password-encrypting a workbook

These features address different problems. Protect Sheet is mainly an editing control: it helps preserve the layout or formulas on a worksheet while allowing specific actions. File encryption is intended to restrict access to the workbook itself. If a workbook contains sensitive information and should not be readable by anyone who lacks permission, use encryption rather than relying on sheet protection.

In Excel for Microsoft 365 on Windows, the usual path to encrypt a workbook is File > Info > Protect Workbook > Encrypt with Password. Set a strong password, confirm it, and save the file. The precise labels can vary slightly by Excel version. Unlike sheet protection, encryption prompts for a password to open the workbook, so it applies to access to the file rather than just editing a worksheet.

Keep the distinction in mind when choosing a method. A workbook can have an encrypted opening password, protected sheets, both, or neither. You might encrypt a confidential workbook and also protect its formulas to discourage accidental changes after an authorized person opens it. Sheet protection alone should not be presented as a privacy or confidentiality barrier.

Password choices and recovery

If you set a worksheet password, store it somewhere appropriate, such as an organization-approved password manager, and make sure the people responsible for maintaining the workbook can retrieve it. Passwords must be entered exactly as set, so avoid relying on a vague hint or an informal handoff. Do not put the password in a visible cell on the same worksheet it is meant to protect.

Excel does not provide a normal password-recovery prompt that reveals a forgotten sheet-protection password. If you lose it, look for a backup or an earlier version of the workbook, or ask the person or team that set it. A forgotten password used to encrypt a workbook is a more serious problem because it can prevent opening the file; Microsoft cannot retrieve a lost password for you. Keep a secure backup before applying restrictions to important files.

For team workbooks, document which sheets are protected, which cells are intended for input, and who maintains the password. That small bit of handover information can prevent routine updates from becoming difficult when the original workbook owner is unavailable.

Excel for Mac and Excel for the web

In Excel for Mac, select the worksheet and use the Review tab’s Protect Sheet command. The dialog and some menu details can differ from Windows, but the central workflow is the same: choose allowed actions, optionally set a password, and confirm it. If you cannot find the command, check the Review tab or Excel’s command search, since ribbon arrangements can vary by release.

Excel for the web also supports sheet protection controls, but its interface and available management options may not match the desktop app exactly. If you need to configure detailed permissions, inspect locked and unlocked cells, or troubleshoot a workbook, open it in the desktop version of Excel. Do not assume that a workbook is protected simply because a sheet is protected in one version; verify the protection settings in the version your team uses.

Common problems and practical checks

  • You cannot edit any cells: The cells may all be locked. Unprotect the sheet, unlock the intended input cells through Format Cells > Protection, and protect the sheet again.
  • You can still change a cell: Confirm that the cell is locked and that sheet protection is on. Selecting a cell and inspecting its Locked setting can help distinguish a setup issue from a missing permission.
  • A filter or sort command is unavailable: Unprotect the sheet, update the allowed actions in Review > Protect Sheet, and test again. The permission required depends on the task.
  • You expected the whole workbook to be private: Sheet protection does not stop someone from opening or reading the file. Use file encryption when access to the workbook itself must be restricted.
  • You protected the wrong sheet: Protection is applied to the active worksheet, so check the selected sheet tab before setting it. You can unprotect the unintended sheet and repeat the process on the correct one.

Before distributing a protected workbook, test it as a normal user would: enter data in the intended cells, try a prohibited edit, and check permitted sorting or filtering. If the workbook is important, keep an unprotected master copy in a secure location so an authorized maintainer can make structural changes without rebuilding the file.

Frequently Asked Questions

Can I password protect just one sheet and leave the others editable?
Yes. Select the sheet you want to restrict and choose Review > Protect Sheet. Other worksheets remain unaffected unless you protect them separately.

Do I have to set a password to protect a sheet?
No. You can enable sheet protection without entering a password, but anyone who can access the workbook can then turn protection off without knowing one. Set a password if you want removal to require it.

Can someone view or copy data from a protected sheet?
Protection does not encrypt the worksheet or hide all its contents. It is designed to restrict selected edits, not to prevent viewing or copying. Use workbook encryption when the file itself needs an access password.

Can I use a different password for each sheet?
Yes. Each worksheet can be protected separately, and you can assign different passwords. Keep a reliable record of them so authorized people can maintain the workbook.

What if I forget the sheet password?
Excel does not offer a standard way to reveal a forgotten sheet-protection password. Check for a backup or an earlier version, or contact the workbook owner. For important files, keep a secure unprotected master copy.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.