To protect a worksheet in Microsoft Excel for Microsoft 365 on Windows, open the sheet, choose Review > Protect Sheet, select the actions people may still perform, and optionally enter a password. Before turning protection on, unlock any cells people should be able to edit; sheet protection prevents changes to locked cells but is not a substitute for encrypting a confidential workbook.
What Protect Sheet does
Protect Sheet controls what users can change on one worksheet. You can use it to preserve headings, formulas, layout, or reference data while leaving designated cells open for data entry. For example, a monthly expense template might let staff enter amounts and dates in a few columns while preventing accidental edits to its formulas and labels.
Protection is applied to the active worksheet, not automatically to every sheet in the workbook. A workbook with several tabs may therefore need each relevant sheet protected separately. Protection also does not prevent someone from opening or viewing the workbook, copying information they can see, or making a separate copy of it.
Excel cells have a Locked property, but that property does not by itself stop editing. In a new worksheet, cells are generally marked as locked by default; the setting takes effect only after you protect the sheet. This explains why a cell can appear to be locked in its formatting settings yet remain editable until worksheet protection is enabled.
Protect a worksheet in Excel for Windows
Use these steps in the desktop version of Excel for Microsoft 365. If you want every cell to be read-only, you can protect the sheet without first changing the default cell settings.
- Open the worksheet you want to protect and select the Review tab.
- Choose Protect Sheet in the Protect group.
- In the Protect Sheet dialog box, decide whether to enter a password to unprotect the sheet. A password is optional.
- Review the list of actions that users will be allowed to perform. Keep Select locked cells and Select unlocked cells selected if users should be able to move to both kinds of cells.
- Choose OK. If you entered a password, Excel asks you to enter it again to confirm.
When you return to the worksheet, try editing a locked cell to confirm that protection is active. Excel should prevent the change. If you left a cell unlocked, it should remain editable. Make sure you retain any password you set: worksheet protection does not provide a password-recovery process that guarantees access if the password is forgotten.
Leave selected cells open for data entry
A common setup is to lock most of a sheet and leave a small set of input cells editable. First select the cells users should be able to change. To select separate ranges, hold Ctrl while selecting them. Open Format Cells with Ctrl+1, choose the Protection tab, clear the Locked check box, and choose OK. Then protect the worksheet using Review > Protect Sheet.
For example, suppose a form has labels in column A, user-entered quantities in B2:B20, and calculated totals in C2:C20. Leave the quantity cells unlocked and keep the labels and calculated cells locked. After protection is enabled, users can enter quantities without overwriting the total calculations. The cells in B2:B20 are only an example; use the actual input range in your own workbook.
On a Mac, select the cells and use Command+1 to open Format Cells, then use the Protection tab to clear Locked. The Review tab includes sheet-protection controls in current desktop Excel for Mac, though the wording and placement can vary somewhat by release. Excel for the web also offers worksheet-protection controls, but its available settings can differ from the desktop dialog; use desktop Excel when you need to configure a particular permission precisely.
Choose which actions remain allowed
The Protect Sheet dialog lets you allow specific interactions while keeping other changes blocked. The choices commonly include selecting locked or unlocked cells, formatting cells or rows and columns, inserting or deleting rows and columns, sorting, using AutoFilter, editing objects, and editing scenarios. The options you see depend on the workbook and Excel version.
Choose permissions based on what users actually need rather than enabling everything. For a simple entry form, selecting unlocked cells may be enough. If people need to filter an existing table, allow use of AutoFilter. If they need to format cells, grant that permission deliberately: otherwise, formatting changes are restricted along with changes to locked-cell contents.
- Select unlocked cells: Useful when people should navigate directly among editable input fields.
- Format cells, columns, or rows: Allows the corresponding formatting actions on a protected sheet.
- Sort or use AutoFilter: Allows selected data-management actions, subject to Excel’s restrictions and the layout of the protected range.
- Insert or delete rows and columns: Allow only if changing the sheet’s structure is part of the intended workflow.
Permissions are not a general role system: Excel’s sheet protection does not create individual user accounts with different rights for each person. People working with the protected sheet receive the same set of permissions. If a task depends on one group editing a range while another group cannot, consider how the file is shared and whether a more appropriate access-control method is needed.
Protect Sheet versus Protect Workbook
Protect Sheet and Protect Workbook address different things. Protect Sheet controls editing actions on a worksheet. Protect Workbook, available from the Review tab in desktop Excel, can protect workbook structure, such as adding, deleting, moving, hiding, or renaming sheets. Protecting the structure does not automatically protect the contents of each sheet, and protecting a sheet does not by itself stop someone from changing workbook structure.
A workbook can use both protections. For instance, a template owner might protect the formulas on each worksheet and separately protect the workbook structure so users do not remove or rename tabs. Choose each protection according to the change you want to prevent; do not assume that turning on one kind covers the other.
Sheet protection is not file security
Worksheet protection is primarily a guard against accidental or casual changes. It is not encryption and should not be relied on to keep sensitive information secret from someone who has access to the file. A sheet password limits ordinary editing through Excel’s interface, but it is not equivalent to encrypting the workbook with a password.
If the concern is preventing unauthorized people from opening the file, use file-level encryption rather than relying on Protect Sheet. In Excel for Windows, the file-encryption command is available through File > Info > Protect Workbook > Encrypt with Password. Keep the password somewhere safe: losing an encryption password can make the file’s contents inaccessible. Follow your organization’s approved process for confidential or regulated data, and share the file only with people who should have access.
Also remember that protecting a sheet does not hide its contents from someone who can open the workbook. Hiding a worksheet is not a security measure either. If a recipient should not see particular information, remove it from the shared copy or use an access-controlled system that supports the confidentiality requirement.
Common problems and fixes
A cell is still editable: Check whether sheet protection is actually on, then inspect the cell’s Locked setting. If it was unlocked before protection, editing it is expected. If protection is off, the Locked setting alone does not prevent edits.
Users cannot type in an input cell: Unprotect the sheet, select the intended input cells, clear Locked in Format Cells > Protection, and protect the sheet again. Confirm that Select unlocked cells is allowed if users need to select those cells.
Sorting or filtering does not work: Reopen Protect Sheet and check the relevant permission. Sorting protected ranges can have additional limitations—for example, Excel may be unable to sort a range containing locked cells if doing so would require moving those cells. Test the exact table arrangement and permitted actions before distributing the workbook.
You cannot change a protected setting: Use Review > Unprotect Sheet first. If a password was set, Excel asks for it. Do not assume that changing a cell’s Locked setting while the sheet remains protected will remove protection from that cell.
The password is missing: Excel may not be able to restore a forgotten worksheet-protection password. Ask the workbook’s creator or your organization’s administrator for the authorized password or an unprotected source copy. Avoid treating unofficial recovery tools as a dependable or safe solution, especially for sensitive files.
Plan and test a protected template
Before sharing a protected workbook, make a copy and test it from the perspective of someone filling it in. Try entering values in the intended input cells, changing a formula, formatting a protected area, sorting a table, and using any filters the workbook needs. This catches permission settings that seem reasonable in the dialog but interfere with the actual workflow.
It is also helpful to make editable fields visually obvious. Use a consistent fill color, add instructions near the form, or label required inputs. These visual cues are not security controls, but they reduce confusion and help users avoid trying to edit protected content. If the template contains formulas, consider documenting what the editable cells mean so later maintainers can update the sheet without guessing.
Keep an unprotected master copy in a controlled location. That makes it easier to revise formulas and settings later without relying on the distributed version as the only source. Before making significant changes, save a separate working copy and verify that the final version still has the intended protections.
Frequently Asked Questions
How do I protect only certain cells in Excel?
Select the cells that should remain editable, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, and clear Locked on the Protection tab. Then protect the worksheet. Other cells remain locked if their Locked setting is still selected.
Can I protect an Excel sheet without a password?
Yes. Choose Review > Protect Sheet and leave the password field blank. This turns on the sheet’s editing restrictions, but anyone with access can generally turn protection off without entering a password.
Does Protect Sheet stop people from viewing my data?
No. It restricts worksheet editing; it does not hide data or encrypt the workbook. Use file-level encryption and suitable sharing permissions when the goal is to control access to the contents.
How do I remove protection from a worksheet?
Open the protected sheet and choose Review > Unprotect Sheet. Enter the password if Excel requests one. Without the password, you may need to contact the workbook owner for an authorized unprotected copy.
Does protecting a sheet protect every tab?
No. Sheet protection applies to the worksheet you protect. Protect other worksheets individually if needed, and use workbook-structure protection separately if you want to restrict changes such as adding, deleting, or renaming tabs.
Related
- How to Merge Cells in Excel Without Losing Data Safely
- Excel Table: Make a Plain Data-Only Table From Your Data
- Import Excel CSV Files in Python: A Step-by-Step Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Remove Double Spaces in Excel Without Losing DataTo remove repeated spaces in Excel, select the cells and use Home > Find & Select > Replace…
- Excel Consolidate Multiple Tables into One WorkbookYes. To combine the rows from several similarly structured tables into one refreshable table, use Power Query: convert…
- Excel Profit Analysis Tool: Build One Step by StepAn Excel profit analysis tool can be a simple workbook that compares sales revenue with variable and fixed…
- Excel Not Responding and Won’t Close? Try These FixesIf Excel says Not Responding and will not close, first give it a minute if it may be…
- Stop Flash Fill in Excel: Turn Off Automatic FillingTo stop a Flash Fill that just happened, press Ctrl+Z in Excel for Windows. To prevent automatic Flash…
- Excel Shortcut to Select a RowIn Excel for Microsoft 365 on Windows, press Shift+Spacebar to select the entire worksheet row containing the active…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.