In Excel for Microsoft 365 on Windows, Protect Sheet restricts what people can change on a worksheet; it is a review command, not a formula. Select Review > Protect Sheet, choose the actions to allow, and optionally enter a password. To keep some cells editable, unlock them before you protect the sheet.
What Protect Sheet Does
Protect Sheet helps prevent accidental or unauthorized changes to cells, formulas, and other worksheet elements. It works by applying restrictions to cells marked as locked, along with any limits you select in the protection dialog. Most cells in a new worksheet are marked locked by default, but that setting has no effect until sheet protection is turned on.
Protection is useful when a worksheet is meant to be filled in or reviewed without changing its structure. For example, a monthly expense template might contain formulas that calculate totals. You can leave the input cells open for entries while protecting the total formulas and labels from accidental edits.
Protect Sheet applies to one worksheet at a time. A workbook with several sheets needs protection configured separately on each one. The feature can also limit certain actions, such as formatting cells or inserting rows, depending on the permissions you select.
How to Protect a Worksheet
On Windows, open the worksheet and select Review > Protect Sheet. In the Protect Sheet dialog, choose whether to require a password and select the actions users may perform. Confirm the password if Excel prompts you to do so. The sheet is protected as soon as you complete the dialog.
The dialog usually includes the option to protect the worksheet and the contents of locked cells, followed by a list of permitted actions. The available choices can vary with the worksheet and Excel version. Common options include selecting locked or unlocked cells, formatting cells, inserting or deleting rows and columns, sorting, using AutoFilter, and editing objects.
Choose permissions to fit the task rather than checking everything automatically. If users only need to enter data in designated fields, they may need permission to select unlocked cells but not permission to format or insert rows. If they need to filter a prepared table, allow use of AutoFilter. Test the protected sheet with a typical user task before distributing the workbook.
How to Leave Input Cells Editable
Unlock the cells that users should be able to edit before applying protection. A practical setup for a form or calculator is:
- Select the cells that should accept entries. To select multiple separate ranges, hold Ctrl while selecting on Windows.
- Open Format Cells using Home > Format > Format Cells, or press Ctrl+1 on Windows. On Mac, Command+1 opens Format Cells.
- Open the Protection tab and clear the Locked checkbox, then select OK.
- Protect the sheet using Review > Protect Sheet and choose the permissions that suit the worksheet.
- Try editing both an input cell and a formula cell. The input should remain editable, while the locked formula cell should reject changes.
Clearing Locked does not immediately change the cell’s appearance or prevent edits. It only marks the cell as unlocked for when sheet protection is enabled. Likewise, protecting a sheet without first unlocking input cells will generally leave users unable to edit those cells.
For a clear handoff, use labels, shading, or instructions to show which cells are intended for entry. These visual cues are not security controls, but they reduce confusion. If formulas should not appear in the formula bar, select the formula cells, open Format Cells > Protection, select Hidden, and then protect the sheet. The Hidden setting takes effect only while the worksheet is protected.
What the Permission Choices Mean
Protection does not make every action impossible. It limits actions according to the permissions selected in the dialog. For instance, allowing users to select unlocked cells lets them navigate to open input cells; it does not automatically let them change locked formulas. Allowing formatting or sorting also does not unlock all cells.
Consider the purpose of each permission before enabling it:
- Select locked cells: Users can select protected cells, which may be useful for copying or viewing formula results even when editing is blocked.
- Select unlocked cells: Users can move among cells intended for data entry.
- Format cells, columns, or rows: Users can make the corresponding layout changes, which may undermine a carefully arranged template.
- Insert or delete rows and columns: These actions can affect formulas, references, and the shape of a worksheet.
- Sort or use AutoFilter: These options support working with lists, but protected ranges and locked cells can still limit what operations succeed.
- Edit objects or scenarios: These permissions apply to worksheet elements beyond ordinary cell values.
Permission names are instructions to Excel about allowed actions, not a guarantee that every operation will work in every situation. For example, sorting a protected range can be restricted by locked cells or by the range’s structure even if sorting is permitted. If users need a complex workflow, test that exact workflow after protection is enabled.
How to Unprotect a Sheet
To remove protection in Excel for Microsoft 365 on Windows, open the worksheet and select Review > Unprotect Sheet. If a password was set, enter it when prompted. Once protection is removed, cells marked locked can be edited like other cells; their Locked setting remains in place for any later protection session.
If the sheet was protected without a password, anyone who can access it can generally turn protection off. If a password is required and has been forgotten, Excel does not provide a normal built-in way to recover it. Keep protection passwords in an approved password manager or other secure record, and make sure the workbook owner knows how authorized changes should be requested.
Protection Is Not the Same as Workbook Security
A common misconception is that Protect Sheet encrypts a worksheet or makes its contents confidential. It does not. Worksheet protection is mainly intended to control editing in Excel; it should not be treated as strong protection for sensitive information. Depending on the situation, users may still be able to view or copy visible data, and protection does not replace access controls on the file.
Protect Sheet is also different from protecting a workbook’s structure. Worksheet protection applies to actions on an individual sheet. Workbook structure protection is used to restrict changes such as adding, deleting, moving, or renaming sheets. If the concern is preventing others from opening the file, use file-level encryption with a password instead of relying on sheet protection. In Microsoft 365 for Windows, encryption settings are available through File > Info > Protect Workbook > Encrypt with Password. Use the appropriate option for the actual risk, and keep a secure backup before changing security settings.
Coauthoring and sharing permissions are separate considerations too. If several people need different levels of access, control access through the storage or sharing service as well as setting worksheet protections. A sheet password is not a substitute for managing who can open or edit the workbook.
Common Problems and Fixes
If a cell that should be editable is still blocked, check whether it was unlocked before protection was enabled. Select the cell, open Format Cells > Protection, and confirm that Locked is cleared. Also confirm that you are editing the intended worksheet and that its protection is active; each sheet has its own protection state.
If users cannot filter or sort, reopen the protection settings and review the relevant permissions. Then test the actual table or range: protected-sheet rules can still affect particular operations. If the worksheet needs frequent structural changes, it may be simpler for an authorized person to unprotect it, make the changes, and protect it again afterward.
If the password prompt rejects a password, check for typing errors and confirm that the correct sheet is being unprotected. Sheet-protection passwords are case-sensitive. If the password is unavailable, do not assume that renaming the file or copying the worksheet will recover it; keep an unprotected backup before protection is applied when you are responsible for maintaining the workbook.
Excel for Mac has sheet-protection controls on the Review tab, though dialog layout and labels can differ by build. Excel for the web also has sheet-protection controls, but its interface and available options may differ from the desktop app. If a permission or setup option is missing in the web version, use the desktop app to configure and verify the worksheet.
When to Use Another Approach
Protect Sheet is appropriate when the main goal is to prevent accidental edits while still letting people use a worksheet. It is less suitable when you need to conceal data, enforce strong access control, or manage detailed permissions for different people. In those cases, consider removing sensitive data from the shared file, controlling file access, or using a workflow designed for multiple user roles.
For a simple input form, unlocking only entry cells and protecting the rest is often enough. For a shared report that people only need to read, distribute a read-only copy or use file-sharing permissions as appropriate. For a workbook that requires routine maintenance, document who can unprotect it and keep a separate protected distribution copy. The right choice depends on whether the real concern is accidental editing, workbook structure, or access to the file itself.
Frequently Asked Questions
Is Protect Sheet an Excel function?
No. It is a worksheet-protection command on the Review tab, not a formula or function you enter in a cell.
Can I protect only certain cells?
Protection is applied to the worksheet, but you can unlock selected cells before protecting it. Those unlocked cells remain editable while locked cells are restricted.
Does Protect Sheet stop someone from viewing my data?
No. It limits worksheet editing; it is not a confidentiality or file-encryption feature. Use access controls or file encryption when you need to restrict access to workbook contents.
Can I protect a sheet without a password?
Yes. A password is optional, but without one a person with access to the workbook can generally remove the sheet protection through Excel.
Why can’t I edit a cell after protecting the sheet?
The cell is probably marked Locked, or the sheet’s permissions do not allow the action. Unprotect the sheet, check the cell’s Protection setting, unlock it if appropriate, and protect the sheet again.
Related
- Vertex42 Budget Spreadsheet: How to Get and Use It
- Vertex Debt Snowball Spreadsheet: How to Use It
- Excel Power Query Group By Column: Steps and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Auto Forwarding in Outlook: Setup and Key OptionsTo set up auto forwarding in Outlook, open Settings, choose Mail > Forwarding, turn on forwarding, enter the…
- How to Find the Highest Number in ExcelIf your numbers are in A2:A6, enter =MAX(A2:A6) in an empty cell to return the largest one. For…
- How to Add Page 1 of X in a Word HeaderTo show a live “Page 1 of X” count in a Microsoft Word header, insert a PAGE field…
- Excel Text to Columns: Can You Make It Automatic?No—not for every kind of pasted text. In Excel for Microsoft 365 on Windows, tabs in copied text…
- Excel Page Break Command: Insert, Move, and RemoveIn Excel for Microsoft 365 on Windows, use Page Layout > Breaks > Insert Page Break to add…
- How to Disable Autofit Row Height in Excel ManuallyTo keep Excel row heights from changing, select the rows, turn off Wrap Text if you need a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.