How to Protect a Sheet in Excel: Steps and Tips

How-to basics · Updated November 18, 2026

To protect a sheet in Excel for Microsoft 365 on Windows, open the worksheet, select Review > Protect Sheet, choose which actions people may perform, and optionally enter a password. Protection takes effect only on cells marked as locked, so unlock any cells you want people to edit before turning it on.

What sheet protection does

Protect Sheet is a way to limit changes to a worksheet. It can prevent users from editing locked cells, changing certain formatting, or performing other actions you select in the protection dialog. This is useful when a sheet contains formulas, instructions, or a layout that should remain intact while users enter information in designated areas.

Protection does not automatically make every cell uneditable. Excel cells are marked as locked by default, but that setting has no effect until you protect the sheet. A newly protected sheet will therefore generally prevent editing throughout the sheet unless you first unlock the cells intended for input.

Sheet protection also is not the same as protecting a workbook file with encryption. It is designed to control editing, not to keep confidential information secret from someone who has access to the file. Use file encryption and appropriate access controls when the goal is to restrict who can open or read a workbook.

Protect a sheet in Excel for Windows

These steps apply to the desktop version of Excel for Microsoft 365 on Windows. Decide first whether users should be able to edit any cells; if so, unlock those cells before starting the protection steps below.

  1. Open the workbook and select the worksheet tab you want to protect.
  2. On the ribbon, select Review > Protect Sheet.
  3. In the dialog, leave Protect worksheet and contents of locked cells selected.
  4. Optionally type a password in the password box. If you leave it blank, the sheet can still be protected, but a password will not be required to remove protection.
  5. Choose the actions you want to allow. For example, allow users to select unlocked cells while preventing them from selecting locked cells.
  6. Select OK. If you entered a password, Excel asks you to enter it again to confirm.

After protection is on, try editing a locked cell to confirm that Excel blocks the change. Also test the intended input cells. A quick check can catch a common setup mistake: protecting the sheet before unlocking the cells users need to fill in.

Choose what users can do

The Protect Sheet dialog contains permissions that determine which worksheet actions remain available. The exact combination depends on what the sheet is for. For a simple data-entry form, allowing selection of unlocked cells is often enough. For a worksheet people need to inspect or filter, you may need to permit additional actions.

  • Select locked cells: Users can select cells that are locked, even though they cannot edit them. Clear this option if users should only move among editable cells.
  • Select unlocked cells: Users can select cells that are available for editing. Keep this enabled if the sheet has input fields.
  • Format cells, columns, or rows: These permissions allow corresponding formatting changes. Leave them off if preserving the layout matters.
  • Insert or delete rows and columns: Allow these only when users need to change the sheet’s structure.
  • Sort and use AutoFilter: These options can help users work with lists, but protection settings and the range’s setup can affect what operations are possible.
  • Edit objects or scenarios: These permissions relate to objects such as charts or drawing elements and to scenarios, rather than ordinary cell entry.

Permissions are not a substitute for testing the actual workflow. For instance, a filter may already be applied before protection, yet a user’s ability to change it can depend on the relevant permission. Set only the permissions users need, then test the sheet as a normal user would.

Unlock cells that users should edit

To make selected cells editable on a protected sheet, change their locked setting before you protect the worksheet. Select the cells, open Home > Format > Format Cells, and select the Protection tab. Clear Locked, select OK, and then protect the sheet. In Windows, Ctrl+1 opens Format Cells for the selected cells. In Excel for Mac, Command+1 is the usual shortcut for Format Cells.

For example, imagine a monthly expense template with formulas in column D and blank entry cells in columns A through C. Select the intended entry range in A:C and clear its Locked setting. Leave the formula cells locked. Then protect the sheet and allow selection of unlocked cells. Users can enter descriptions, dates, and amounts without overwriting the formulas.

To check which cells are editable, select a cell and open Format Cells > Protection before protection is enabled. The Locked checkbox shows the cell’s setting. You can also unlock a whole input range at once, but take care not to include formula cells by mistake. If you later add new rows, confirm that their cells have the intended locked setting before users work in them.

Set, change, or remove a password

A password is optional when you protect a sheet. Without one, users may be able to remove protection through the Review tab without entering a password. With one, Excel requests that password when someone attempts to unprotect the sheet. Choose a password that can be stored and shared appropriately with the people responsible for maintaining the workbook.

To change a sheet’s password, first select Review > Unprotect Sheet and enter the current password if prompted. Then protect the sheet again with the new password. Excel does not provide a way to reveal a forgotten sheet-protection password through the normal protection dialog, so keep a record in a suitable password manager or other secure location.

Sheet protection should not be relied on as strong security for sensitive data. It is an editing restriction, not file encryption. If you need to require a password before someone can open the workbook, use File > Info > Protect Workbook > Encrypt with Password in Excel for Microsoft 365 on Windows. Encryption protects access to the file itself; it serves a different purpose from protecting an individual sheet.

Protect one sheet, a workbook, or a file?

Excel offers several protections with similar names but different effects. Choosing the right one avoids the mistaken assumption that protecting one worksheet also prevents changes everywhere else in a workbook.

  • Protect Sheet limits selected actions on one worksheet, such as editing locked cells. It does not automatically protect the other sheets.
  • Protect Workbook can protect the workbook’s structure, restricting actions such as adding, deleting, moving, or renaming sheets. On Windows, find it on the Review tab as Protect Workbook.
  • Encrypt with Password requires a password to open the workbook. Find it at File > Info > Protect Workbook > Encrypt with Password in Excel for Microsoft 365 on Windows.

These protections can be used for different needs. For example, a workbook can have one protected template sheet, a protected workbook structure, and encryption for opening the file. Consider who needs to open the file, who needs to change its structure, and who needs to enter data before selecting the controls.

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 lets you set a password and choose permitted actions, although labels and available controls can differ slightly from Windows. The general workflow is the same: unlock input cells first, protect the sheet, and test the permitted actions.

In Excel for the web, look on the Review tab for Manage Protection and use the sheet-protection controls available in that interface. The browser version’s controls and options may differ from the desktop dialog. If a particular permission or protection task is not available in the browser, open the workbook in the Excel desktop app and use its Review commands. Avoid assuming that a workbook’s desktop settings can all be changed from the web interface.

Common problems and fixes

  • Users cannot type in the intended input cells: The cells may still be locked. Unprotect the sheet, clear Locked for the input range in Format Cells > Protection, and protect the sheet again.
  • Users can still change cells: Check that the sheet—not just the workbook structure—is protected. Also confirm that the cells in question are locked and that protection was applied to the correct worksheet tab.
  • Users cannot sort or filter: Review the permissions selected in Protect Sheet. Allow the relevant sorting or AutoFilter action when appropriate, and test the actual list after protection.
  • The password does not work: Check capitalization, keyboard layout, and whether the password belongs to this specific sheet. Sheet passwords are not necessarily the same as a password used to open the workbook.
  • A newly added range behaves differently: New cells may not have the same Locked setting or formatting as nearby cells. Check their protection settings and test them after reapplying sheet protection.

When troubleshooting a shared workbook, make a copy before changing protection settings. This gives you a safe version to compare against if unlocking a range or changing permissions affects the template’s formulas or layout.

Frequently Asked Questions

Can I protect only certain cells in Excel?
Yes. Unlock the cells that people may edit, leave the other cells locked, and then protect the sheet. Protection applies to the locked cells while the unlocked cells remain available for entry.

Can people edit cells without a password?
Yes. A password is optional, and users can edit unlocked cells on a protected sheet without entering the protection password. The password is used to restrict removal of sheet protection, not to authorize ordinary entry in unlocked cells.

Does Protect Sheet stop someone from opening the workbook?
No. Protect Sheet controls editing on a worksheet after the workbook is open. To require a password to open a workbook in Excel for Microsoft 365 on Windows, use File > Info > Protect Workbook > Encrypt with Password.

How do I unprotect an Excel sheet?
Select the sheet, then choose Review > Unprotect Sheet. Enter the password if Excel requests it. If no password was set, protection can be removed without one.

Why are formulas visible even after I protect a sheet?
Protect Sheet prevents changes to locked cells; it does not automatically hide their contents. To hide formulas from the formula bar, select the formula cells, open Format Cells > Protection, select Hidden, and then protect the sheet. Test the result, because the Hidden setting takes effect only while sheet protection is on.

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.