To protect part of an Excel sheet, unlock the cells people may edit, leave the cells you want protected locked, then choose Review > Protect Sheet. Excel applies cell locking only after sheet protection is turned on, so setting which cells are locked is the essential first step.
How worksheet protection works
In Excel for Microsoft 365 on Windows, cells are marked as locked by default. That setting alone does not stop anyone from changing them. It takes effect when you protect the worksheet. This lets you set up a sheet so that selected cells can be changed while formulas, labels, or other fixed content cannot be edited accidentally.
Protection applies to a worksheet, not to an arbitrary patch of cells by itself. You choose which cells are locked or unlocked, then protect the sheet. When protection is on, Excel blocks changes to locked cells according to the options you selected. Unlocked cells remain available for entry. You can also decide whether users may select locked cells, format cells, insert rows, sort, and perform other actions.
This is useful for forms, budgets, schedules, and templates. For example, a sales sheet might let staff enter quantities in column B while keeping product names in column A and calculation formulas in column C protected. The worksheet stays usable without making every cell editable.
Protect selected cells step by step
Use this approach when most of the sheet should remain editable and only a few cells need protection. The steps assume that the cells are currently locked, which is Excel’s default for a new worksheet.
- Select the cells that people should be able to edit. To select separate areas, hold Ctrl while selecting additional ranges.
- Press Ctrl+1 to open Format Cells. Choose the Protection tab, clear the Locked check box, and select OK. On Mac, use Command+1 to open Format Cells.
- On the ribbon, choose Review > Protect Sheet.
- In the Protect Sheet dialog, optionally enter a password. Select the actions users should be allowed to perform while the sheet is protected. For an input form, users commonly need to select unlocked cells.
- Select OK. If you entered a password, Excel asks you to enter it again to confirm.
Now the cells you unlocked can be edited, while the other locked cells are protected. Try changing one cell of each type to confirm the result. If you leave the password field blank, the sheet can still be protected against routine edits, but anyone can turn off protection without entering a password.
Protect only a small part of the sheet
If nearly all cells should be editable and only a few must be protected, reverse the setup: unlock the entire worksheet first, then lock the particular cells to protect. Do this before turning on protection.
- Select the worksheet’s cells using the Select All button at the upper-left corner of the grid, where the row and column headings meet.
- Press Ctrl+1, open the Protection tab, clear Locked, and select OK. On Mac, use Command+1.
- Select the cells that should be protected. Open Format Cells again, choose Protection, select Locked, and choose OK.
- Choose Review > Protect Sheet and set the allowed actions and optional password.
For instance, if a worksheet contains a large data-entry area but a small instruction box that must not be changed, unlocking everything and then locking the instruction cells may be simpler than selecting every editable cell. Be careful with the Select All button: it affects the whole sheet, so check that you have not already protected or configured cells in a way you need to preserve.
Choose what users can do
The Protect Sheet dialog controls more than whether users can type in locked cells. Its check boxes let you balance protection with the actions people need to do their work. The exact combination depends on the sheet and the task; allowing more actions can make the sheet easier to use but may expose more of its layout to change.
- Select unlocked cells: Lets users move to and edit unlocked input cells. This is usually important for a form.
- Select locked cells: Lets users select protected cells, for example to copy their contents or inspect a formula in the formula bar. Clear it if users should navigate only among editable cells.
- Format cells, columns, or rows: Allows the corresponding formatting changes. Leave these options off if the layout needs to stay consistent.
- Insert or delete rows and columns: Permit these only when users genuinely need to change the sheet’s structure. Inserting or deleting can affect nearby data and formulas.
- Sort and use AutoFilter: These options can be useful in a protected data table. Set up the filter before protecting the sheet, and test the specific operations users need; protection can restrict actions involving locked cells.
Protection does not give each user a separate view or guarantee that a permitted action will behave exactly as it does on an unprotected sheet. Test the protected worksheet with a representative set of entries and actions before distributing it.
Let users edit a particular range
Excel for Windows desktop also has an Allow Edit Ranges feature for cases where you want to protect a sheet but make one or more ranges editable under separate conditions. On the Review tab, choose Allow Edit Ranges, create a range, and specify its cell reference. Depending on the Excel environment, a range can be associated with a password or with user permissions supported by the organization.
This can be useful when different people are responsible for different sections, or when a range needs a different password from the rest of the protected sheet. It is not the same as simply unlocking cells: the range settings define an exception within a protected worksheet. The feature’s user-permission options depend on the Windows and organizational environment, so check what your Excel installation supports. For a straightforward form, unlocking input cells and protecting the sheet is usually easier to manage.
On Mac and Excel for the web, controls and feature availability can differ from Windows desktop. If a workbook relies on range permissions or other advanced protection settings, configure it in desktop Excel for Windows and test how it behaves in the apps your collaborators will use.
Passwords, security, and what protection does not do
Worksheet protection is mainly intended to prevent accidental or casual edits. It is not a secure way to hide confidential information, and it should not be treated as strong access control for sensitive data. A recipient may be able to copy information, make another copy of the workbook, or use tools outside Excel to work around worksheet-level restrictions. Hidden rows, hidden columns, and hidden formulas are not a substitute for keeping private data out of a shared file.
If the goal is to stop people from opening a workbook without authorization, use file-level encryption rather than relying on Protect Sheet. In Excel for Microsoft 365 on Windows, the path is File > Info > Protect Workbook > Encrypt with Password. File encryption is different from protecting a worksheet: it controls access to the workbook file, while sheet protection limits editing after the file is open. Use a strong, unique password and share it through an appropriate channel.
Keep a record of any worksheet or workbook passwords. If you forget a worksheet-protection password, Microsoft does not provide a normal in-Excel recovery button for it. Do not assume that a password on a protected sheet is a backup or privacy safeguard. Before applying protection to an important workbook, save a separate copy so that you can recover the original layout if settings need to be changed.
Troubleshoot common protection problems
- Users cannot edit a cell that should be editable: Turn off sheet protection, select the cell, and check Format Cells > Protection. Clear Locked, then protect the sheet again. Also confirm that the cell is not part of a protected range or otherwise restricted.
- Users can still edit cells you meant to protect: Confirm that the sheet is protected and that the cell’s Locked setting is selected. Locking a cell without protecting the sheet does not prevent edits.
- The whole worksheet became locked: This often happens when the editable cells were not unlocked before protection. Unprotect the sheet, unlock the intended input cells, and protect it again.
- A filter or sort command is unavailable: Unprotect the worksheet and review the permitted actions in the Protect Sheet dialog. Set up AutoFilter before protecting, then test sorting and filtering on the actual table.
- You cannot change protection settings: You must unprotect the worksheet first. If a password is requested, you need the password set by the workbook’s owner.
When troubleshooting, distinguish a worksheet from a workbook. A protected worksheet restricts edits to cells and sheet features. Workbook-structure protection, available through Review > Protect Workbook, restricts changes such as adding, deleting, moving, or renaming sheets. These settings solve different problems and may be used together.
When to use another approach
Cell protection is helpful when people need to enter information into a shared template, but it is not always the best way to manage a multi-person workflow. If several people need to update the same data, consider storing the workbook in OneDrive or SharePoint and using the access and sharing controls there. Those controls manage who can access or edit a file; they do not replace the need to design a clear worksheet.
For data that should be reviewed before it becomes part of a master record, collect responses in a separate input sheet or workbook and have an owner transfer approved information. For confidential details, remove them from the shared workbook rather than hiding them or locking their cells. For a form that must enforce rules, use data validation as well as protection: validation can restrict the kind of value entered, while protection controls whether a cell can be edited at all.
A practical design often combines these measures. For example, unlock the cells where staff enter dates and quantities, apply data validation to limit acceptable entries, protect formula cells, and store the workbook in a location with appropriate sharing permissions. Each measure addresses a different risk.
Frequently Asked Questions
Can I protect only one cell in Excel?
Yes. Unlock the cells that should remain editable, leave the target cell locked, and turn on worksheet protection with Review > Protect Sheet. If the target is the only cell that needs protection, unlock the rest of the worksheet first.
How do I let people edit some cells but not others?
Select the cells they may edit, open Format Cells with Ctrl+1, clear Locked on the Protection tab, and then protect the worksheet. On Mac, use Command+1 for Format Cells. Locked cells are protected only when sheet protection is on.
Can I protect formulas but leave input cells editable?
Yes. Keep formula cells locked, unlock the input cells, and protect the worksheet. You can also hide formulas using the Hidden setting in Format Cells before protecting the sheet, but hiding a formula is not a security measure and does not conceal the result shown in the cell.
Does Protect Sheet encrypt my Excel file?
No. It restricts certain changes to a worksheet after someone opens the workbook. To require a password to open the file, use File > Info > Protect Workbook > Encrypt with Password in Excel for Microsoft 365 on Windows.
What if I forget the sheet-protection password?
Excel does not offer a standard in-app method to retrieve a forgotten worksheet-protection password. Keep a secure record of passwords and retain an unprotected backup when appropriate. Worksheet protection should not be used to protect the only copy of important data.
Related
- No Remove Duplicates Option in Excel? Find It
- No Hyperlink in Excel? Remove or Prevent Links
- Excel File Corrupted? How to Check, Repair, and Recover
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Dropdown Limit to List: Setup, Limits, and FixesYes. In Excel for Microsoft 365 on Windows, use Data Validation to make a cell accept values from…
- Sunday Service in Google Sheets: Planning and SchedulingYes. Google Sheets can serve as a shared planning sheet for a Sunday church service: use it to…
- Excel Sharing Violation: Causes and FixesAn Excel sharing violation usually means Excel cannot save to the workbook because another user, program, or file-system…
- Common Excel Shortcut Keys and How to Use ThemThe most useful Excel shortcut keys on Windows include Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to…
- Excel Dependent Drop-Down Lists With Spaces: Setup GuideYes. In Excel for Microsoft 365 on Windows, you can make a dependent drop-down work when a category…
- Reseller Inventory Spreadsheet: Track Stock and ProfitA reseller inventory spreadsheet is a workbook for recording what you buy, what you sell, what remains in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.