Yes. In Excel for Microsoft 365 on Windows, go to Review > Protect Sheet, choose which actions users may perform, enter a password if you want one, and confirm it. Sheet protection helps prevent accidental or unauthorized changes to selected cells; it does not encrypt the workbook or keep people from viewing its contents.
How to protect a sheet with a password
Open the worksheet you want to protect and choose Review > Protect Sheet. In the dialog, you can enter a password to unprotect the sheet and select the actions that should remain available. Choose options such as selecting unlocked cells or using AutoFilter, depending on how the sheet is meant to be used. Select OK, enter the password again when prompted, and confirm.
The password field is optional. If you leave it blank, Excel still turns on protection, but anyone can turn it off by choosing Review > Unprotect Sheet. A password makes that action require the password you set. Excel asks you to confirm it when protection is first enabled, which helps catch typing mistakes.
For example, a monthly expense worksheet might contain formulas for totals alongside blank cells where staff enter dates and amounts. You can leave the input cells editable, protect the sheet, and permit users to select unlocked cells. They can enter expenses without casually overwriting the total formulas. Protection applies to the active worksheet; repeat the process for each sheet that needs its own protection settings.
What sheet protection actually does
Excel treats cell locking and sheet protection as two related but separate settings. Many cells in a new worksheet are marked as locked by default, but that setting does not prevent editing until you protect the sheet. Once protection is active, Excel restricts changes to locked cells and to other worksheet features according to the permissions you selected.
This means sheet protection is useful for guiding ordinary editing, preserving formulas, and reducing accidental changes. It is not a view-only mode: users can generally read the values and formulas they are permitted to see, and they may still be able to select cells or use allowed worksheet features. It also does not hide data. If information should not be shared with someone, do not rely on protecting or hiding a sheet as a substitute for controlling access to the file.
Protection settings belong to each worksheet, not to the entire workbook as a single switch. A workbook can therefore have one protected calculation sheet, one editable data-entry sheet, and another unprotected sheet. The password and allowed actions can differ from sheet to sheet.
Prepare editable cells before protecting the sheet
If users should enter information in only a few places, unlock those cells before turning on protection. This is a useful step for forms, templates, and shared trackers. Select the cells intended for input, open Home > Format > Format Cells or press Ctrl+1, choose the Protection tab, clear Locked, and select OK. Then protect the worksheet using the Review tab.
On a Mac, the equivalent shortcut for opening Format Cells is usually Command+1. You can also use the Format Cells command from the ribbon or context menu. The wording and placement of controls can vary slightly by Excel version, but the key idea is the same: mark the intended input cells as unlocked first, then enable sheet protection.
Check the sheet after protection is on. Try entering a value in an input cell, then try changing a formula cell. If the wrong cells are editable, unprotect the sheet, revise the Locked setting, and protect it again. You can also use cell formatting, such as a fill color or a short instruction, to make editable cells obvious to users; formatting is a visual cue, not a security control.
Choose which actions users can perform
The Protect Sheet dialog lets you allow some actions while blocking others. The exact list can vary somewhat with Excel versions, but common permissions include selecting locked or unlocked cells, formatting cells or columns, inserting rows, sorting, and using AutoFilter. Keep the permissions focused on what people need to do rather than enabling everything by default.
- Data-entry template: Allow users to select unlocked cells. Leave formatting and structural changes disabled unless the workflow requires them.
- Filtered report: Set up the filter before protecting the sheet, then allow use of AutoFilter if users need to change the filter choices.
- Shared log: Permit inserting rows only if new records need to be added, and check that this works with the sheet’s layout and formulas.
Some combinations of worksheet features and protection permissions can be restrictive. For instance, users may be unable to sort a protected range if the relevant cells are locked. If a permission does not behave as expected, unprotect the sheet, test the arrangement on a copy, and adjust both the cell locking and the permitted actions.
Sheet protection versus workbook passwords
Excel has several protections with similar names, but they solve different problems. Protect Sheet restricts editing on one worksheet. Protect Workbook can restrict changes to workbook structure, such as adding, deleting, moving, renaming, or hiding sheets. Neither setting is the same as requiring a password to open the file.
To encrypt a workbook with a password to open it in Excel for Microsoft 365 on Windows, use File > Info > Protect Workbook > Encrypt with Password. This is the more relevant option when the goal is to prevent people without the password from opening and reading the workbook. It protects the file itself rather than simply restricting changes to a worksheet. Treat that password as essential: if it is lost, Microsoft cannot retrieve it for you.
Choose the protection that matches the need. If coworkers should be able to read a schedule but not change formulas, protect the worksheet. If they may edit data but should not rearrange the workbook’s tabs, protect the workbook structure. If the file contains confidential information and should not be readable by people who lack permission, use file encryption and share the password securely. These options can be combined, but one does not automatically provide the others.
Security limits and password handling
Worksheet protection is best understood as an editing safeguard, not strong information security. It can deter accidental changes and ordinary edits through Excel’s interface, but it should not be treated as a way to conceal sensitive information or resist a determined person with access to the file. A password on a sheet is not equivalent to encryption of the workbook.
Use a unique password that you can store securely, especially if other people will need to unprotect the sheet later. Excel passwords are case-sensitive, so capitalization matters. Avoid putting the password in a visible note on the same worksheet. If several people need authorized access, use an approved password manager or another secure method to share it, and make sure someone responsible for the workbook can retrieve it.
If you forget a worksheet-protection password, Excel does not provide a normal reset button that reveals the original password. Keep an unprotected backup or maintain a secure record of passwords when appropriate. Before applying protection to a business-critical file, save a separate copy and verify that the people who need to maintain it can still do so.
Remove or change sheet protection
To remove protection in Excel for Microsoft 365 on Windows, open the protected sheet and select Review > Unprotect Sheet. Enter the password if Excel requests it. Once the sheet is unprotected, you can edit cells and settings normally. To change the password, first unprotect the sheet, then choose Review > Protect Sheet again and set the new password and permissions.
Removing protection does not erase the worksheet or its contents; it changes the editing restrictions. If the password is incorrect or unavailable, Excel will not accept the normal unprotect action. Do not assume that making a new copy or renaming the file will remove the protection. For important files, plan password ownership before protecting them rather than relying on recovery afterward.
Excel for Mac and Excel for the web
In Excel for Mac, worksheet protection is also available from the Review tab, and the dialog provides settings for a password and permitted actions. The interface may be arranged differently from Windows. Use Command+1, rather than Ctrl+1, for the Format Cells shortcut on Mac when you need to unlock input cells before protecting the sheet.
Excel for the web can work with protected worksheets, but its available controls may differ from the desktop application and can change as Microsoft updates the service. If you need to configure detailed permissions, change protection settings, or resolve a password prompt, open the workbook in the desktop version of Excel and use the Review tab. If you are collaborating in a browser, check the protected sheet’s behavior before relying on it as a shared form.
Common problems and practical checks
A frequent surprise is that a cell marked Locked remains editable until sheet protection is turned on. Another is that a user can select a cell but cannot type in it: selecting cells and editing them are different actions, and the protection settings determine what is allowed. If an input area is blocked, verify that its cells are unlocked and that the right selection permissions are enabled.
Before distributing a protected workbook, check the following:
- Confirm that the intended input cells are unlocked and formula or label cells are locked.
- Test the permitted actions using a copy of the file, including filters or row insertion if users need them.
- Make sure the password is recorded or shared through a suitable secure method.
- Keep a backup, especially if the worksheet is part of a recurring process.
If the sheet is protected but users can still see confidential values, that is expected: sheet protection does not hide content. Remove data they should not receive, or protect the workbook with an open password and share it only with authorized people.
Frequently Asked Questions
Can I protect a sheet without a password?
Yes. Choose Review > Protect Sheet and leave the password field blank. Excel will apply the selected editing restrictions, but anyone can unprotect the sheet without entering a password.
Can people still view a password-protected sheet?
Usually, yes. A worksheet password restricts editing; it does not encrypt or conceal the sheet’s contents. Use workbook encryption with a password to open the file when you need to restrict access to its contents.
Can I protect only certain cells?
Yes. Unlock the cells users should edit through Format Cells > Protection, leave other cells locked, and then protect the worksheet. Protection is turned on at the sheet level, while the Locked setting determines which cells are restricted.
Does protecting a sheet protect every sheet in the workbook?
No. Protect each worksheet separately if you want editing restrictions on multiple sheets. Workbook structure protection is a separate setting for limiting changes to the workbook’s tabs and structure.
What if I forget the sheet password?
Excel does not provide a standard feature to reveal or reset a forgotten sheet password. Keep a secure record or a suitable unprotected backup, and do not rely on sheet protection to safeguard information that must remain confidential.
Related
- How to Create a Hyperlink in Excel: Links to Files and Pages
- How to Hyperlink in Excel on a Mac: Web, Files, and Cells
- Detect Circular References in Excel: Step-by-Step
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 Add a Checkbox in Excel With Words Beside ItTo add a clickable checkbox with words beside it in Microsoft Excel for Microsoft 365 on Windows, select…
- SUMIF Negative Values in Google Sheets: ExamplesIf your values are in A2:A7, enter =SUMIF(A2:A7,"<0") to add only the negative numbers; for example, -12, 8,…
- Excel Data Analysis: Tools, Steps, and LimitsYes. Excel can generate data analysis by summarizing tables, calculating results, finding patterns, and creating charts or reports;…
- Excel Table Multiple Header Rows: What WorksNo. An Excel Table can have only one header row: the first row of the table range supplies…
- Excel Power Query: Extract Text from a StringTo extract text in Excel Power Query, select the relevant column and use Transform > Extract to choose…
- Excel Mini Calendar and Date Picker: Your OptionsExcel for Microsoft 365 on Windows does not include a universal pop-up calendar that you can attach to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.