In Excel for Microsoft 365 on Windows, protect a sheet by opening the worksheet, choosing Review > Protect Sheet, selecting the actions you want to allow, and optionally entering a password. Before you do, unlock any cells people should be able to edit; sheet protection only takes effect after you turn it on.
Protect a worksheet in Excel
Sheet protection is set separately for each worksheet. To enable it in the desktop version of Excel for Microsoft 365 on Windows:
- Open the worksheet you want to protect. If you need some cells to remain editable, unlock them first; the next section explains how.
- Go to Review > Protect Sheet.
- In the Protect Sheet dialog, decide whether to enter a password. A password is optional, but it can prevent someone from turning protection off casually.
- Review the list of permitted actions. For example, you can allow users to select unlocked cells while preventing them from changing locked cells.
- Select OK. If you entered a password, Excel asks you to confirm it.
Try the result by selecting a cell that should be restricted and attempting to edit it. Then test an input cell, if you made one editable. Protection applies to the active worksheet, not automatically to every sheet in the workbook. Repeat the process on each tab that needs its own protection settings.
In Excel for Mac, the equivalent command is also on the Review tab, usually as Protect Sheet; the dialog layout and some available options can differ. Excel for the web has sheet-protection controls under Review, but the options available can vary from the desktop app. If a setting you need is missing, open the workbook in the desktop version.
Unlock cells that people should be able to edit
By default, cells in a new worksheet are marked as locked. That setting does not stop editing by itself: it only becomes effective after sheet protection is switched on. A common setup is to leave labels, formulas, and reference data locked while unlocking only the cells intended for user input.
To unlock input cells in Windows, select them, press Ctrl+1 to open Format Cells, choose the Protection tab, clear Locked, and select OK. Then protect the sheet using Review > Protect Sheet. On a Mac, Command+1 opens Format Cells; the Protection tab is also where you change the Locked setting.
For example, a simple order-entry sheet might have product descriptions in column A, calculated totals in column D, and quantity-entry cells in column C. Keep the descriptions and formulas locked, unlock the intended quantity cells, and then protect the sheet. Users can enter quantities without being able to overwrite the formulas by mistake. The cells are still part of the same worksheet; unlocking them does not hide or validate their contents.
To check a cell’s setting, select it and open Format Cells > Protection. If the Locked box is selected, that cell will be protected when sheet protection is on. You can select a whole input range before changing this option. Take care not to unlock formula cells just because they are near the input area; a selection mistake can leave calculations editable.
Choose what protected-sheet users can do
The Protect Sheet dialog lets you choose which actions remain available. The exact list can depend on the Excel version, but common choices include selecting locked or unlocked cells, formatting cells, rows, or columns, inserting rows or columns, deleting rows or columns, sorting, using AutoFilter, and using PivotTable reports. Choose only the permissions the worksheet actually needs.
For an input form, allowing users to select unlocked cells is often enough. If they need to filter a table, allow use of AutoFilter as well. If they need to adjust column widths, allow formatting columns. These permissions do not automatically make every operation work in every situation: for instance, an existing filter may be usable when allowed, but protection can still limit changes to the underlying table or its layout.
Some commands can be unavailable or behave differently while a sheet is protected. If users need to sort or work with PivotTables, test that workflow with the precise options selected. Protection is not a substitute for trying the workbook as an ordinary user. Also remember that allowing formatting may let users change the appearance of locked cells even though they cannot change their values.
Use a password carefully
A sheet-protection password is optional. Without one, users can generally turn off protection through the Review tab without being asked for a password. With one, Excel asks for the password when someone tries to unprotect that sheet. Passwords are case-sensitive, so capitalization matters.
Store the password somewhere appropriate and make sure the people responsible for maintaining the workbook can retrieve it. If it is lost, Excel does not provide a normal password-recovery control for removing sheet protection. A forgotten password can therefore make routine editing difficult, even when the workbook owner has a legitimate reason to change it.
Most importantly, sheet protection is not strong security for confidential information. It is designed mainly to prevent accidental edits and limit ordinary changes to a worksheet, not to encrypt the workbook or stop a determined person from accessing its contents. Do not use it as the only protection for sensitive data. Use appropriate file-level access controls and encryption, and avoid including information that workbook recipients should not see.
Unprotect a sheet or change its settings
To remove protection in Excel for Microsoft 365 on Windows, open the protected worksheet and choose Review > Unprotect Sheet. If Excel requests a password, enter the password that was set for that sheet. Once protection is removed, locked cells can be edited like other cells; their Locked settings remain in place for the next time you protect the worksheet.
If you need to change permissions, unprotect the sheet, make the required changes, and protect it again with the revised options. If an unlocked input cell has accidentally been left locked, unprotect the sheet, change its setting through Format Cells > Protection, and enable protection again. This sequence is usually clearer than trying to diagnose a blocked edit without first checking the cell’s Locked setting and the sheet’s current protection status.
Sheet protection is not workbook protection
Excel has different protection features for different purposes. Protect Sheet controls permitted actions on one worksheet. It does not, by itself, prevent someone from opening the workbook or changing its overall structure.
Protect Workbook is a separate Review-tab command concerned with workbook structure. It can restrict actions such as adding, deleting, moving, hiding, or renaming sheets, depending on the settings and version. It does not replace protection on individual worksheets: if you need to restrict both cell edits and changes to the sheet tabs, configure the relevant protections separately.
File encryption is different again. If the goal is to require a password to open a workbook, use Excel’s file-encryption option rather than relying on Protect Sheet. In Microsoft 365 for Windows, the file-level controls are available through File > Info > Protect Workbook > Encrypt with Password. Treat that password as essential access information, and keep a separate secure copy of it.
Common problems and practical checks
If Excel says a cell is protected when you try to edit it, the usual explanation is that the worksheet is protected and the cell is still marked Locked. Check both conditions: select the cell and inspect Format Cells > Protection, then check whether Review offers Unprotect Sheet. If only certain cells should be editable, unlock those cells before turning protection back on.
If protection appears to do nothing, confirm that you used Protect Sheet on the correct worksheet. A workbook can contain several tabs, and protection on one does not automatically cover the others. Also check that you are testing a locked cell: an unlocked cell remains editable by design.
- Formula cells can still be visible. Locking a cell prevents edits under sheet protection; it does not conceal the formula. Excel also has a separate Hidden option in Format Cells > Protection, but formula hiding takes effect only when the sheet is protected. It is not a secure way to keep a formula secret.
- Protection does not validate entries. If users must enter a number within a range or choose from a list, configure data validation separately. Protection controls editing permissions; validation controls which entries Excel accepts.
- Protection can affect automation and workflows. Macros, external tools, and some table or PivotTable tasks may need specific permissions or adjustments. Test the actual tasks users perform before distributing a protected workbook.
- Shared editing needs a deliberate setup. If several people edit a workbook, agree on which ranges are inputs and who can change formulas or layout. Sheet protection helps reduce accidental changes, but it does not replace sharing permissions or a clear process for maintaining the workbook.
Frequently Asked Questions
How do I protect only certain cells in Excel?
Unlock the cells that should remain editable through Format Cells > Protection, then protect the worksheet. Cells left marked Locked will be restricted while the sheet is protected.
Can I protect a sheet without a password?
Yes. In the Protect Sheet dialog, leave the password field blank and confirm. Users can generally remove protection without a password, so this is useful mainly for reducing accidental edits, not for access control.
Does protecting a sheet stop people from seeing formulas?
No. Locked cells are still visible. You can mark formulas as Hidden in Format Cells > Protection and then protect the sheet, but this is not a reliable way to secure confidential formulas or data.
Can I protect every worksheet at once?
Protect Sheet applies to the active worksheet, so you need to configure each sheet separately. Protecting workbook structure is a different feature and does not lock the cells on every tab.
What if I forget the sheet-protection password?
Excel does not offer a standard password-recovery command for removing sheet protection. Keep a secure record of passwords and preserve an authorized editable copy before applying protection.
Related
- Excel Shortcut to Select Visible Cells in a Filtered Range
- Excel Save As Shortcut: Windows, Mac, and Web
- Excel Shortcut to Select All Data: What Ctrl+A Selects
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: Why Can’t I Group Columns? Causes and FixesIf you can’t group columns in Excel, the usual causes are a protected worksheet, an unsuitable selection, or…
- Excel Data Validation From a Table Column: How to Set It UpTo make an Excel drop-down list from a table column, create a workbook-level name that refers to the…
- How to Enter an Absolute Cell Reference in ExcelTo enter an absolute reference in Excel, put the cursor on a cell reference inside a formula and…
- Excel Shortcut to Move Between Tabs: Windows and MacIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet tab, or…
- How to Change Font Size in Outlook Email ViewTo make messages easier to read in Outlook, adjust the reading-pane zoom in classic Outlook for Windows, or…
- Automate Text to Columns in Excel: Methods and LimitsYes—but Excel’s Text to Columns command does not automatically repeat itself whenever new data arrives. For a one-time…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.