In Excel for Microsoft 365 on Windows, protect a worksheet by opening it and choosing Review > Protect Sheet, selecting the actions users may perform, and optionally entering a password. To remove protection later, choose Review > Unprotect Sheet and enter that password if Excel asks for it.
What protecting a worksheet actually does
Worksheet protection is a way to prevent accidental changes to cells, formulas, and certain worksheet features. It is useful when a workbook is a form, template, or report that other people need to use without changing its structure. For example, you might protect a monthly expense sheet so colleagues can enter amounts in designated cells but cannot overwrite the formulas that calculate totals.
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 worksheet. Once protection is turned on, locked cells cannot normally be edited, while unlocked cells remain available for entry. Protection can also limit actions such as formatting rows, sorting, or inserting columns, depending on the permissions you choose.
This feature is specific to a worksheet. A workbook can contain several sheets, and protecting one does not protect the others. It is also different from encrypting a workbook with a password to open it: worksheet protection is intended mainly to control editing, not to keep a determined person from accessing sensitive information.
How to protect a sheet in Excel
Before protecting a sheet, decide which cells should remain editable and whether users need to perform actions such as filtering or sorting. Then use these steps in Excel for Microsoft 365 on Windows:
- Open the worksheet you want to protect. Protection is applied to the active sheet, not automatically to every sheet in the workbook.
- On the ribbon, select Review > Protect Sheet.
- In the Protect Sheet dialog box, leave Protect worksheet and contents of locked cells selected.
- In the list of permitted actions, select the tasks users should still be able to perform, such as selecting unlocked cells or using AutoFilter.
- Enter a password if you want Excel to require one to turn protection off, then select OK. Excel asks you to enter the password again to confirm it.
A password is optional. If you leave it blank, users can generally turn off protection through Review > Unprotect Sheet without entering a password. If you do set one, record it somewhere appropriate: Excel does not provide a normal password-recovery option for worksheet protection.
After protection is enabled, try the sheet as a user would. Check that an unlocked input cell accepts a value and that a locked formula cell cannot be overwritten. This quick check can reveal a setup mistake before the workbook is distributed.
Choose which cells people can edit
To create an editable area, first select the cells users are meant to change. You can select a range by dragging across it or by entering a reference in the Name Box, to the left of the formula bar. For example, in a simple request form, you might leave cells B3:B8 editable for names and quantities while keeping the labels and calculation cells locked.
With the intended input cells selected, open the Format Cells dialog. One way is to right-click the selection, choose Format Cells, and open the Protection tab. Clear the Locked checkbox, then select OK. You can also reach Format Cells from the Home tab using the Format menu. When you later protect the worksheet, those unlocked cells remain editable.
To prevent users from seeing formulas in the formula bar, select the formula cells, open Format Cells > Protection, and select Hidden as well as Locked. The Hidden setting takes effect only after sheet protection is turned on. It conceals formulas from ordinary viewing in the formula bar; it is not a secure way to store confidential logic or data.
A practical layout often uses color or a brief instruction to distinguish input cells from calculated cells. Color is only a visual cue, not a protection setting. Confirm the actual Locked status in Format Cells rather than assuming that a colored cell is editable.
Set permissions in the Protect Sheet dialog
The Protect Sheet dialog controls which actions remain available while the worksheet is protected. The exact list can depend on the worksheet and Excel version, but common options include selecting locked or unlocked cells, formatting cells or rows, inserting or deleting rows and columns, sorting, using AutoFilter, and using PivotTable reports. Allow only the actions the workbook genuinely needs.
For an entry form, allowing users to select unlocked cells while leaving locked cells unselectable can make it easier to move through the form without accidentally landing on formulas. If people need to use existing filters, allow Use AutoFilter. That permission allows use of filter controls that are already in place; it does not necessarily let users create a new AutoFilter while protection is active.
Sorting and filtering can interact with locked cells and ranges. A permission checkbox does not guarantee every operation will work in every layout. Test the actual sheet, especially if it contains tables, merged cells, hidden rows, or formulas. If users need broader editing freedom, a protected sheet may not be the right arrangement.
How to unprotect a worksheet
To remove protection in Excel for Microsoft 365 on Windows, activate the protected worksheet and select Review > Unprotect Sheet. If a password was set, type it in the prompt and confirm. Once unprotected, cells marked Locked can be edited normally, and users can change worksheet features that had been restricted.
Unprotecting a sheet does not erase the Locked or Hidden settings in cell formatting. It simply turns off the protection that enforces those settings. If you protect the sheet again later, the same locked cells become restricted again unless you change their formatting first.
If the workbook contains multiple protected sheets, repeat the process for each one that needs to be edited. Worksheet protection is separate from workbook-structure protection, so removing a sheet’s protection does not necessarily let you rename, move, hide, or delete worksheets if the workbook structure is also protected.
Common problems and useful checks
- A cell still cannot be edited: It may be locked, or the active sheet may still be protected. Check Review for the Unprotect Sheet command, then inspect the cell in Format Cells > Protection.
- A cell can be edited even though the sheet is protected: That cell may have been marked unlocked before protection was enabled. Review its Locked setting and protect the sheet again if needed.
- You cannot remember the password: Excel does not offer a standard way to reveal or recover a worksheet-protection password. Ask the workbook owner or administrator, check approved password records, or find an unprotected backup. Do not confuse this with a password used to encrypt a file.
- A sort or filter command is unavailable: Unprotect the sheet, adjust the allowed actions in Protect Sheet, and test again. Some operations are limited by the layout or by other protection settings.
- You need to change the sheet structure: Protection may be applied to the workbook structure as well as to individual sheets. Check Review for Protect Workbook and distinguish that setting from Protect Sheet.
When adjusting an established workbook, make a copy first if the sheet contains important formulas or carefully configured controls. Protection settings are easy to change, but a mistaken edit to a formula or input range may be harder to spot later.
Protection is not the same as security
Worksheet protection is best treated as an editing safeguard, not as encryption or access control for confidential material. It helps prevent routine or accidental edits, but it should not be used as the sole defense for private data, trade secrets, or regulated information. A person who can open a workbook may be able to copy visible content even if they cannot edit protected cells.
If the goal is to restrict who can open the file, use Excel’s file-level encryption option instead. In desktop Excel, the file password setting is available through File > Info > Protect Workbook > Encrypt with Password. This is a different feature from Review > Protect Sheet. Store file passwords securely, because losing an encryption password can prevent access to the workbook.
For shared workbooks, consider the storage location and sharing permissions too. OneDrive or SharePoint access controls can help determine who may view or edit the file, while sheet protection determines which edits are allowed within a worksheet. These controls solve different problems and may be used together.
Worksheet protection, workbook protection, and file passwords
Excel has several features with similar names, so it helps to choose by purpose. Protect Sheet limits changes to a particular worksheet. Protect Workbook can protect the workbook structure, such as preventing sheets from being added, deleted, moved, hidden, or renamed. Encrypt with Password requires a password to open the file.
For example, a team might protect a calculation sheet so its formulas are not changed, protect workbook structure so users do not remove the template tabs, and share the file only with approved colleagues. None of those settings replaces the others. If the objective is only to make a few cells editable, worksheet protection and cell locking are usually the relevant tools.
Differences on Mac and Excel for the web
The steps above are for Excel for Microsoft 365 on Windows. Excel for Mac also supports worksheet protection and cell locking, though dialog placement or wording can vary by build. Look on the Review tab for the sheet-protection command and use Format Cells to adjust the Locked setting. On Mac, keyboard shortcuts can differ, so these instructions rely on ribbon paths rather than Windows-only shortcuts.
Excel for the web has its own ribbon and may expose a different protection interface or a more limited set of controls than desktop Excel. If you do not see the same Protect Sheet dialog or need to adjust detailed permissions, open the workbook in the desktop app and use the Windows or Mac instructions there. In a shared file, you may also need edit permission from the file owner before changing protection settings.
Frequently Asked Questions
Can I protect only certain cells in Excel?
Yes. Mark the cells users should edit as unlocked in Format Cells > Protection, then protect the worksheet. Locked cells will be restricted, while the unlocked cells remain available.
Does protecting a sheet prevent someone from viewing its data?
No. Worksheet protection mainly limits editing. It is not a substitute for file encryption or access permissions, and it should not be relied on to hide sensitive information.
Can I unprotect an Excel sheet without the password?
If a password was set, Excel’s normal Unprotect Sheet command requires it. There is no standard password-recovery feature; contact the workbook owner or use an authorized unprotected copy.
Why can I edit a locked cell on a sheet that is not protected?
The Locked setting only restricts editing when sheet protection is turned on. Until you choose Review > Protect Sheet, a cell marked Locked behaves like a normal editable cell.
Does Protect Sheet apply to every tab in my workbook?
No. It protects the active worksheet only. Protect each sheet separately if needed, and use Protect Workbook when you want to restrict changes to workbook structure.
Related
- Import CSV to Rows in Excel: Methods, Steps, and Fixes
- Import Excel Data and Export to CSV: A Practical Guide
- Import Multiple CSV Files into Excel: Fast Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Breaks for Printing: How to Add Them EasilyTo add a page break in Excel for Microsoft 365 on Windows, select the row below where the…
- How to Delete a Page With Content in Microsoft WordTo delete a page that contains text, pictures, or other content in Microsoft Word for Microsoft 365 on…
- Password Protect a Tab in Excel: What Actually WorksYes. In Excel for Microsoft 365 on Windows, select the worksheet tab, go to Review > Protect Sheet,…
- Clean an Excel Spreadsheet: Steps for Cleaner DataTo clean an Excel spreadsheet, make a copy, standardize text and data types, resolve blanks and duplicates, and…
- Excel Date Without Year: Display a Date Without Its YearTo show an Excel date without its year, select the date cells, press Ctrl+1 on Windows, choose Number…
- How to Add a First Page Header in Word: Simple StepsTo add a header that is different on page one in Microsoft Word, open the header, select Different…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.