Yes. In Excel for Microsoft 365 on Windows, mark the cells you want to protect as locked, then choose Review > Protect Sheet; the lock takes effect only after sheet protection is turned on. You can leave selected cells unlocked so people can enter data while preventing edits to formulas, labels, or other content.
How cell protection works
Excel applies protection at the worksheet level, not as a separate on-off switch for each cell. Each cell has a Locked setting, which is turned on by default in a new worksheet. That setting does not stop editing by itself. It becomes effective when you protect the sheet, at which point users cannot change locked cells through normal worksheet editing.
This two-part arrangement is useful because most worksheets contain both fixed content and areas for input. You can keep calculation formulas locked while allowing users to enter quantities, dates, or assumptions. You can also protect everything, or unlock particular ranges before protecting the sheet.
Protection settings are not a substitute for restricting access to sensitive information. A protected sheet can still be viewed, and sheet protection is intended to prevent accidental or routine changes rather than provide strong data security. Use file encryption or access controls when confidentiality matters.
Protect a sheet while allowing selected cells to be edited
For a typical form or calculation sheet, leave formula and heading cells locked and unlock only the input cells. In Excel for Microsoft 365 on Windows:
- Select the cells that people should be able to edit. To select separate areas, hold Ctrl while selecting each range.
- Press Ctrl+1 to open Format Cells. Select the Protection tab, clear the Locked checkbox, and choose OK. Alternatively, use Home > Format > Format Cells, then open Protection.
- Choose Review > Protect Sheet.
- In the Protect Sheet dialog, optionally enter a password. Review the list of actions users may perform on the protected sheet and leave enabled only the actions they need.
- Choose OK. If you entered a password, Excel asks you to confirm it.
The selected cells remain editable, while other locked cells are protected. For example, a budget template might leave the cells for monthly amounts unlocked and keep the total formulas and category names locked. Test the result by trying to change one input and one formula cell.
Choose which cells are locked
Because cells are locked by default, you generally do not need to lock formula cells one by one. The usual approach is to unlock the intended input cells first, then protect the sheet. If the worksheet has been customized before, check its actual settings rather than assuming every cell is still locked.
To reverse the pattern and lock only a particular group, select the entire worksheet using the Select All button at the intersection of the row and column headings. Open Format Cells with Ctrl+1, choose Protection, clear Locked, and confirm. Then select the cells to protect, open the same Protection tab, check Locked, and confirm. Finally, turn on sheet protection. This can be useful when most of a worksheet is a working area but a few cells contain fixed reference values.
The Hidden option on the Protection tab is different from Locked. It can hide a formula from the formula bar after the sheet is protected, but it does not conceal the cell’s displayed result. If you need to hide formulas from casual viewing, select the formula cells, check both Locked and Hidden, and then protect the sheet. Neither setting encrypts the formula or makes the workbook confidential.
Set permissions for protected sheets
The Protect Sheet dialog lets you choose actions that remain available while protection is on. Depending on the worksheet and Excel version, options include selecting locked or unlocked cells, formatting cells or columns, inserting rows, sorting, and using AutoFilter. The right choices depend on how the sheet is meant to be used.
For a simple form, allow selection of unlocked cells and consider whether users need to select locked cells at all. For a data-entry table, they may need to sort or filter; enable those actions only if they are part of the workflow. Protection can interact with features in unexpected ways, so try the permitted actions with a representative user account or a copy of the workbook before distributing it.
If different people need to edit different areas, Excel for Windows desktop also has Review > Allow Edit Ranges. This lets you define editable ranges on a sheet before protecting it, and it can support range-specific passwords or permissions in supported setups. It is more involved than unlocking a few input cells, so it is worth testing carefully, especially when the workbook is shared.
Protecting a worksheet is not the same as protecting a workbook
Protect Sheet controls editing on an individual worksheet. Protect Workbook, found on the Review tab in desktop Excel, is generally used to protect workbook structure—for example, to prevent users from adding, deleting, moving, hiding, or renaming sheets. It does not replace the cell-level setup on each worksheet.
To require a password to open a file, use the file-encryption option instead: in Windows desktop Excel, choose File > Info > Protect Workbook > Encrypt with Password. This is distinct from a worksheet password. Keep a secure record of passwords and test access before sending an encrypted file; losing the opening password can prevent access to the workbook.
Passwords, limits, and sensible safeguards
A sheet password is optional. You can protect a sheet without setting one, which helps guard against accidental edits but does not require a password to turn protection off. If you set a password, anyone who needs to change the sheet’s protection will need to know it. Excel does not provide a dependable way to recover a forgotten protection password, so store it securely and retain an unprotected master copy where appropriate.
Worksheet protection should not be treated as a barrier against someone determined to extract or alter data. It does not hide the sheet’s contents, stop someone from making a copy of visible information, or encrypt the workbook. For confidential files, control who can access the file and use file encryption; for shared workbooks, use the storage service’s sharing permissions as well.
For practical reliability, save a separate working copy before changing protection settings. Record which ranges are intended for input, add clear instructions near those cells, and test the protected worksheet with the same operations users are expected to perform. This reduces the chance of locking a needed input or allowing edits to a formula by mistake.
Common problems and how to fix them
- Users can still edit a cell: Check that the sheet is protected and that the cell’s Locked setting is checked. A locked cell is editable until protection is enabled.
- Users cannot enter data: Select the intended input cells, clear Locked in Format Cells > Protection, and protect the sheet again. If the sheet was already protected, you may need to unprotect it first.
- A formula is visible: Locked does not hide a formula. Select the formula cell, check Hidden in Format Cells > Protection, and protect the sheet.
- A filter or sort does not work: Review the actions allowed in the Protect Sheet dialog. Protection settings can restrict these operations, so enable the needed permission and retest.
- You cannot change protection: Choose Review > Unprotect Sheet and enter the password if prompted. If the password is unavailable, look for an authorized unprotected copy or ask the workbook owner.
When troubleshooting, check that you are protecting the correct worksheet. A workbook can contain several sheets with different protection settings, and protecting one sheet does not automatically protect the others.
Excel for Mac and Excel for the web
The core principle is the same on Mac: set the Locked status for cells, then protect the worksheet. Menu placement and dialog details can vary by release. In desktop Excel for Mac, use the Review tab’s sheet-protection command and open Format Cells to adjust cell protection; Command+1 is the Mac equivalent of Ctrl+1 on Windows.
Excel for the web supports worksheet protection, but some advanced protection options and management tasks are more limited or differ from desktop Excel. If you cannot find a particular permission or range-protection feature in the browser, open the workbook in the desktop app. When a workbook is shared, coordinate edits and protection changes with collaborators, since a protection setting affects other people using that sheet too.
Frequently Asked Questions
Can I protect only certain cells in Excel?
Yes. Unlock the cells users should edit, leave the others locked, and then protect the worksheet. Excel applies the settings to the cells that remain locked, rather than requiring a separate protection command for each cell.
Can I protect cells without a password?
Yes. Choose Review > Protect Sheet and leave the password field blank. This helps prevent routine edits, but a user can turn protection off without supplying a password.
Can people see formulas in protected cells?
Usually, they can see a formula in the formula bar if they select its cell. To hide the formula from the formula bar, check Hidden in Format Cells > Protection and then protect the sheet. The displayed result remains visible.
Does protecting a sheet stop people from copying its data?
No. Sheet protection is designed mainly to restrict editing, not to keep worksheet contents secret. Use file encryption and appropriate access permissions if people should not be able to view the workbook.
How do I remove cell protection?
Choose Review > Unprotect Sheet. If the sheet has a password, enter it. To make individual cells editable afterward, select them, open Format Cells > Protection, and clear Locked; the change matters when the sheet is protected again.
Related
- Can Excel Interpolate Data? Methods and Examples
- Can AI Replace Excel Jobs? The Work It Can Do
- Calendar Timeline Template Excel: Build Your Own
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel PivotTable Testing: Checks, Steps, and Common FixesTo test an Excel PivotTable, compare its results with a small source dataset whose totals you can verify…
- Resize a Picture in an Excel Cell: Step-by-StepTo resize a picture in an Excel cell, place it in the cell, then change the cell’s row…
- Excel Protect Sheet but Allow Grouping: What WorksIn Excel for Microsoft 365 on Windows, you can protect a worksheet after creating row or column groups,…
- Excel Take Data From a Table: Methods and ExamplesYes. Excel can take data from a table by referencing its columns in a formula, filtering or looking…
- Google Sheets Checkbox Conditional Formatting GuideTo apply conditional formatting to a Google Sheets checkbox, select the cells you want to format, open Format…
- Dropdown List in PowerPoint: Options and Setup GuidePowerPoint does not offer a built-in dropdown list like Excel’s data-validation menu. In PowerPoint for Microsoft 365 on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.