To protect a worksheet in Microsoft Excel for Microsoft 365 on Windows, open it and choose Review > Protect Sheet. Select the actions people may still perform, optionally enter a password, and confirm; to remove protection later, choose Review > Unprotect Sheet and enter the password if one was set. Sheet protection mainly prevents accidental changes—it is not a substitute for encrypting a workbook that contains confidential information.
What a protected sheet does
Excel worksheet protection lets you restrict certain actions on one sheet, such as changing locked cells, formatting rows, or inserting columns. It is useful when a workbook is meant to be filled in or reviewed without allowing someone to overwrite formulas, headings, or carefully arranged content. For example, a sales template might let staff enter quantities in a few columns while keeping the calculation cells and summary headings protected.
Protection is applied separately to each worksheet. A workbook can therefore contain a protected input sheet, an unprotected notes sheet, and a protected report sheet. The setting does not, by itself, prevent someone from opening the file, viewing its contents, copying data, or making a separate copy. The exact actions available depend on the permissions selected when protection is turned on.
One important detail is that Excel marks cells as locked by default, but that setting has no practical effect until you protect the sheet. Protection activates the locked status and applies the rules in the Protect Sheet dialog. This lets a workbook author prepare which cells should be editable before enabling the restriction.
How to protect a worksheet
In Excel for Microsoft 365 on Windows, open the sheet you want to restrict and follow these steps:
- Choose Review > Protect Sheet.
- In the dialog, select the actions that users should be allowed to perform. For an ordinary input form, allowing users to select unlocked cells is often enough.
- Enter a password if you want to require one to turn protection off. You can leave the password field blank if the goal is simply to prevent casual or accidental edits.
- Choose OK. If you entered a password, type it again when Excel asks you to confirm it.
The options matter: a protected sheet can still permit actions such as formatting cells, sorting, using AutoFilter, or inserting rows if you explicitly allow them. Choose only the permissions the workflow needs. If users must filter a table, for instance, allow use of AutoFilter rather than assuming that all interactions with a protected sheet will remain available.
On Excel for Mac, use the Review tab and its sheet-protection command; dialog wording and layout can differ slightly by release. Excel for the web has its own Review protection controls, and the available settings may vary. If you cannot find a setting or need finer control, open the workbook in the desktop app.
Make only selected cells editable
A common setup is to leave formulas protected while allowing people to enter data in designated cells. First mark the input cells as unlocked, then protect the sheet. With the target cells selected in Windows Excel, press Ctrl+1 to open Format Cells, choose the Protection tab, clear Locked, and select OK. Then protect the worksheet using Review > Protect Sheet.
On a Mac, select the cells and press Command+1 to open Format Cells; the Protection tab is where you clear the Locked setting. Then apply sheet protection from the Review tab. The same principle applies on either platform: unlocking a cell alone does not protect the rest of the sheet, and protecting a sheet without first unlocking input cells will usually make those cells uneditable too.
For a workbook with several separate input areas, you can select each area and clear its Locked setting before protection. You can also use Review > Allow Edit Ranges in supported Windows desktop versions to define ranges users may edit, with optional range-specific access controls. That feature is useful when different people need permission to edit different parts of a shared worksheet, but it is not a replacement for file access controls.
Choose useful protection permissions
The Protect Sheet dialog is a practical way to tailor the sheet to its purpose. A worksheet used as a data-entry form may need very few permissions, while a protected report may need to allow sorting, filtering, or selection of cells. Consider the task from the user’s point of view before enabling protection; overly strict settings can make a sheet difficult to use even when the data is not at risk.
- Select unlocked cells: lets users move to and enter data in cells you have unlocked.
- Select locked cells: permits selecting protected cells, which can be useful for reading or copying visible results.
- Format cells, columns, or rows: permits the relevant formatting changes without granting permission to edit locked values.
- Sort or use AutoFilter: can keep common list operations available, subject to the sheet’s contents and the selected permissions.
- Insert or delete rows and columns: allows structural changes that may affect formulas or layout, so enable these only when they are part of the intended workflow.
These settings are not a guarantee that every command will behave exactly as it does on an unprotected sheet. For example, sorting can be restricted by locked cells in the range, and features such as PivotTables or macros may need their own testing. Try the protected workbook using a typical user’s actions before distributing it.
Sheet protection, workbook protection, and encryption
Excel has several controls with similar names but different purposes. Protect Sheet applies restrictions to the active worksheet. Protect Workbook can protect the workbook’s structure, limiting changes such as adding, deleting, moving, hiding, or renaming sheets. Neither option should be confused with a password required to open an encrypted file.
To protect workbook structure in Windows desktop Excel, use Review > Protect Workbook and configure the available options. This can help preserve a carefully organized set of tabs, but it does not encrypt the file or lock the contents of each worksheet against edits. Sheet protection and workbook-structure protection can be used together when both kinds of accidental changes need to be limited.
If your concern is that unauthorized people might open or read the workbook, use file encryption instead. In Windows Excel, the route is File > Info > Protect Workbook > Encrypt with Password. A person must then provide the opening password to access the encrypted workbook. Keep that password somewhere secure: losing it can make the file inaccessible. Encryption is the relevant control for confidentiality; sheet protection is mainly a way to manage editing within an open workbook.
What sheet protection does not secure
Worksheet protection is designed to guide editing and prevent unintended changes, not to serve as strong security for sensitive information. It does not hide the fact that data exists in the file, and it should not be relied on to keep confidential values secret from someone who can access the workbook. Depending on the permissions, users may still be able to select or copy visible cells, or save another copy of the file.
For sensitive workbooks, combine appropriate access permissions for the file or storage location with encryption where needed. Avoid distributing data that recipients should not see, even if it is on a hidden or protected sheet. Hidden sheets are a convenience for organizing a workbook, not a confidentiality boundary. If a business or organization has requirements for handling sensitive data, follow its approved security and sharing policies.
Common problems and practical fixes
If users say they cannot type into an input cell, check whether that cell was unlocked before protection was applied. Select it, open Format Cells, and inspect the Protection tab. If it is locked, unprotect the sheet, clear Locked for the intended input range, and protect the sheet again. Also check whether the user is on the correct sheet; protection is configured per worksheet.
If a user cannot sort or filter, review the permissions selected in the Protect Sheet dialog. Sorting and filtering are separate permissions, and protected ranges can impose additional constraints. If the workbook uses tables, PivotTables, or other interactive features, test the specific operation rather than assuming that permitting one related action will enable every feature.
If Excel asks for a password when you try to unprotect the sheet, it is asking for the password set by the person who protected it. Microsoft does not provide a way to retrieve a forgotten worksheet-protection password. Ask the workbook owner or administrator for the password or an authorized unprotected copy. If you own the file, look for a backup or an earlier version in the storage service’s version history. Be cautious with third-party password-removal tools, especially for confidential workbooks or files governed by workplace rules.
Another source of confusion is that protecting a sheet does not prevent edits to unlocked cells. That is intentional in a form or template. Conversely, a cell that looks editable may still be locked, or a permitted action may be blocked by another setting. Test the workbook after protection by trying both a permitted input and a change that should be refused.
When to use a different approach
Use sheet protection when the main goal is to reduce accidental edits while keeping a workbook usable. It works well for templates, calculators, standard reports, and forms with designated entry fields. For a workbook that several people edit at once, consider whether a shared data-entry tool, a controlled SharePoint or OneDrive workflow, or a database-backed form would better manage permissions and conflicting changes.
For confidentiality, use access controls and file encryption rather than relying on protected or hidden worksheets. For a document that recipients should not change at all, distributing a PDF may be more suitable, although that also removes the flexibility of a live spreadsheet. The right choice depends on whether the need is to prevent mistakes, control collaboration, or keep information private; those are separate problems and may require separate controls.
Frequently Asked Questions
Can I protect just one sheet in an Excel workbook?
Yes. Select that worksheet and choose Review > Protect Sheet. Other sheets keep their existing protection settings, so protect them separately if needed.
Can people edit some cells on a protected sheet?
Yes. Before protecting the sheet, select the cells that should accept input, open Format Cells, and clear Locked on the Protection tab. Then protect the sheet.
Is Excel sheet protection secure?
It is useful for limiting edits and preventing accidents, but it is not strong confidentiality protection. Use file encryption and appropriate access controls when you need to restrict who can open or read a workbook.
How do I remove protection if I know the password?
Open the sheet and choose Review > Unprotect Sheet. Enter the password when prompted. In Excel for the web, use the sheet-protection controls on the Review tab; exact labels may differ.
What if I forgot the sheet-protection password?
Ask the workbook owner for the password or an authorized copy, or recover an earlier version from a backup or version history. Microsoft cannot retrieve a forgotten worksheet-protection password.
Related
- Excel Shortcut to Insert a Row: Windows and Mac
- Java Code to Compare Two Excel Files with Apache POI
- Find Similar Names in Excel: Fuzzy Matching
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Consolidate Multiple Tables into One WorkbookYes. To combine the rows from several similarly structured tables into one refreshable table, use Power Query: convert…
- Calculate Between Two Dates in Excel: Days, Months & YearsTo calculate elapsed days between two dates in Excel, put the earlier date in A2 and the later…
- Can You Create Your Own Outlook Email Distribution List?Yes. You can create a personal list of recipients in Outlook and use it to address one email…
- Adjust Freeze Panes in Excel: Steps and FixesTo adjust freeze panes in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Unfreeze…
- Excel Page Break Preview: How to View and Adjust PagesExcel Page Break Preview shows how a worksheet will be divided into printed pages. In Excel for Microsoft…
- Excel Very Hidden Sheets: What They Are and How to Use ThemExcel very hidden sheets are worksheets that do not appear on the sheet-tab bar and cannot be restored…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.