Yes. In Excel for Microsoft 365, select the cells people should be able to change, clear their Locked setting, and then choose Review > Protect Sheet. Protection takes effect only after the sheet is protected, so cells left locked become read-only while unlocked cells remain editable.
Unlock selected cells before protecting the sheet
On Excel for Microsoft 365 for Windows, use this sequence:
- Select the cells that should remain editable. To select separate ranges, hold Ctrl while selecting each range.
- Press Ctrl+1 to open Format Cells, then select the Protection tab.
- Clear the Locked checkbox and select OK. The cells are now marked as unlocked, but the setting does not restrict or permit editing by itself.
- Go to Review > Protect Sheet. In the dialog, choose the actions users should be allowed to perform, such as selecting unlocked cells.
- Optionally enter a password, confirm it if Excel asks, and select OK.
After protection is on, users can enter or change values in the unlocked cells. They cannot edit locked cells unless the sheet is unprotected or a permitted editing range applies. Save the workbook after setting protection, and consider testing it by trying to edit one unlocked cell and one locked cell.
How Excel cell locking works
Excel marks cells as locked by default in a new worksheet. That default is easy to misunderstand: the Locked property does not stop edits while the sheet is unprotected. It becomes effective only when you use Protect Sheet. This lets you prepare a worksheet by leaving most cells locked and selectively unlocking input areas.
For example, a monthly expense template might have labels, formulas, and totals in locked cells, with the cells for date, category, and amount unlocked. When the sheet is protected, contributors can fill in those inputs without overwriting the formulas or headings. The protection applies to the worksheet, not just to the cells you originally selected.
Locked is a cell-format property, so it can be changed in Format Cells for a selection, row, column, or entire sheet. If a workbook has been designed by someone else, check whether cells were already unlocked before changing settings; otherwise, you may unintentionally make input areas editable or lock areas that users need.
Choose what users may do on a protected sheet
The Protect Sheet dialog controls more than cell entry. Its checkboxes determine which actions remain available while protection is on. The exact choices can vary with the Excel version, but common options include selecting locked or unlocked cells, formatting cells or columns, inserting rows, sorting, and using AutoFilter.
Choose only the permissions the worksheet needs. For a simple form, allowing selection of unlocked cells is often enough. If people need to filter a table, enable the AutoFilter option and set up the filter before protecting the sheet. Users generally cannot turn filtering on or off while the protected sheet is active. Sorting on a protected sheet can also be restricted when the sort range includes locked cells.
Allowing users to select locked cells does not let them edit those cells; it only allows selection. Conversely, if you clear the option to select locked cells, users may find it easier to move among permitted inputs without accidentally landing on protected formulas. Try the chosen settings with a typical user workflow, because permitting an action does not always mean every operation involving protected cells will work.
Allow editing in a range with separate permissions
For a more controlled setup, Excel for Windows includes Allow Users to Edit Ranges on the Review tab. This feature lets you define a range on a protected worksheet and, optionally, assign a password to that range. It is useful when some users need to edit a particular area while the rest of the sheet stays protected. In managed work environments, Windows domain permissions may also be available, depending on the organization’s setup.
- On the Review tab, choose Allow Users to Edit Ranges.
- Select New, enter a name for the range, and specify the cell reference.
- If appropriate, set a range password or use the available permissions option for your environment, then confirm the range settings.
- Protect the worksheet with Review > Protect Sheet.
Range permissions are different from simply unlocking cells: they provide an additional way to control access to an area, but they do not replace worksheet protection. A range password is also not a substitute for secure file access. Check the available controls in your Excel edition and organization, because advanced permission options can depend on platform and configuration.
Practical example: protect formulas but leave inputs open
Suppose a worksheet has product names in column A, quantities in column B, unit prices in column C, and calculated totals in column D. If people should enter quantities and prices but not alter product names or totals, select the intended input cells in columns B and C, clear Locked in Format Cells, and protect the sheet. Leave columns A and D locked. Users can then enter order details while the calculated area remains protected.
Before enabling protection, verify that the formulas and reference data are in the right places. If users need to add new product rows, simply unlocking existing input cells may not be enough: inserting rows is a separate permission, and a protected sheet can limit that action. One practical design is to prepare more blank input rows than are initially needed, unlock the intended input cells in those rows, and test whether the permitted actions fit the actual process.
For a shared form, clear instructions can prevent confusion. Add labels such as Enter values in the shaded cells, and consider using a consistent fill color for input areas. Color is only a visual cue; it does not grant permission. The Locked setting and sheet protection determine whether Excel allows the edit.
What worksheet protection does not secure
Protect Sheet is mainly a way to prevent accidental or routine changes to worksheet content and structure. It is not a security boundary for confidential information. Microsoft describes worksheet protection as protection against modifying locked cells, not as a way to encrypt the workbook or prevent a determined person from accessing its contents.
If the goal is to keep a file private, use appropriate file access controls and, where suitable, workbook encryption rather than relying on a protected sheet. In Windows Excel, workbook encryption is available through File > Info > Protect Workbook > Encrypt with Password. Menu wording and location can differ on Mac. Treat passwords carefully: a forgotten sheet-protection password can be difficult to recover, and worksheet protection should not be treated as a reliable recovery or privacy mechanism.
Sheet protection is also distinct from protecting workbook structure. Worksheet protection controls editing on a particular sheet; workbook-structure protection restricts actions such as adding, deleting, moving, or renaming sheets. A workbook can use either feature or both, depending on what needs to be prevented.
Common problems and how to fix them
- Unlocked cells still cannot be edited: Confirm that the intended cells were selected when you cleared Locked, and check whether another protection setting or permission applies. Also verify that the sheet is protected and that the user is working in the correct worksheet.
- Locked cells remain editable: The sheet may not actually be protected. The Locked checkbox alone does not block editing. Use Review > Protect Sheet and confirm that protection is active.
- Users cannot sort or filter: Review the options selected in Protect Sheet. Set up AutoFilter before protecting the worksheet, and test sorting with the locked cells in the target range; protection can prevent certain sorts.
- The protection password is rejected: Check for typing errors and keyboard layout issues. If the password is unavailable, ask the workbook owner or administrator. Keep an unprotected backup when designing a workbook rather than relying on an assumed password-recovery method.
- New cells do not have the expected behavior: Cells added or copied into a protected sheet may inherit formatting and protection settings in ways that differ from the original input area. Test how users will add content, or prepare and unlock the required rows in advance.
Windows, Mac, and Excel for the web
The steps above use Excel for Microsoft 365 on Windows. In Excel for Mac, select the cells and open Format Cells with Command+1; use the Protection tab to clear Locked, then use the Review tab to protect the sheet. Windows uses Ctrl+1 for Format Cells. Ribbon labels and the placement of advanced range-permission controls can differ by platform, so consult the Review tab in the desktop app if a control is not visible.
Excel for the web can work with protected worksheets, but its available protection setup and advanced permission controls may differ from the desktop application. If you need to define cell locking or configure Allow Users to Edit Ranges and cannot find the relevant controls in the browser, open the workbook in the desktop version of Excel. When working in a shared workbook, remember that sheet protection governs allowed edits; it does not replace file-sharing permissions or determine who can open the workbook.
Frequently Asked Questions
Can I protect a sheet but leave certain cells editable?
Yes. Clear Locked for the cells that should be editable, then protect the worksheet. All other cells that remain locked are protected while sheet protection is active.
Do I need a password to protect an Excel sheet?
No. A password is optional in the Protect Sheet dialog. Without one, protection can still restrict the selected actions, but a user who can access the workbook may be able to turn protection off without entering a password.
Why does Excel let me edit a cell marked Locked?
Because Locked is only a setting until the worksheet is protected. Use Review > Protect Sheet to make the locked-cell restriction take effect.
Can users edit only their own cells?
Allow Users to Edit Ranges can define ranges with separate permissions in supported desktop configurations. For stronger control over who can access a workbook, combine appropriate file-sharing or organizational permissions with worksheet settings.
Does protecting a sheet hide its formulas?
No. Protection can prevent editing, but it does not automatically hide formulas. A formula can be hidden through the Hidden option in Format Cells, and the sheet must then be protected; this is still not encryption or a way to keep workbook contents confidential.
Related
- How to Insert a Row in an Excel Spreadsheet: Quick Steps
- How to Make a Heat Map in Excel Using Color Scales
- How to Insert a Row in Excel: Steps, Shortcuts & Tips
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 Delete Duplicate Entries in ExcelTo delete duplicate entries in Excel for Microsoft 365 on Windows, select the full data range, choose Data…
- How to Insert a Table of Contents in Microsoft WordTo insert an automatic table of contents in Microsoft Word for Microsoft 365 on Windows, apply built-in heading…
- How to Find Hidden Tabs in ExcelTo find a hidden worksheet in Excel for Microsoft 365 on Windows, right-click any visible sheet tab, choose…
- Excel Bar Names: What Each Part of the Window DoesIn Excel for Microsoft 365 on Windows, the main interface areas people call “bars” include the title bar,…
- Insert a Personal Signature in Word for Mac: Steps & TipsTo insert a personal signature in Word for Mac, save a picture of your handwritten signature, then choose…
- Google Sheets Filter: Show Only the Rows You NeedTo filter data in Google Sheets, select a cell in your table and choose Data > Create a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.