Excel Protect Cells in a Sheet: Setup, Limits, and Tips

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, unlock the cells people should be able to edit, then choose Review > Protect Sheet and set the allowed actions. Worksheet protection prevents changes to cells that remain locked; it does not encrypt the workbook or make its contents confidential.

What worksheet protection does

Excel separates a cell’s Locked setting from worksheet protection. Cells are generally marked as locked by default, but that setting has no practical effect until you protect the worksheet. After protection is turned on, Excel blocks edits to locked cells while leaving unlocked cells available for entry. This lets you protect a template’s labels, calculations, and layout without preventing users from filling in designated fields.

For example, imagine an expense form with descriptions in column A, amounts in column B, and a total formula at the bottom of column B. You could unlock the cells where users enter descriptions and amounts, leave the total formula locked, and protect the sheet. Users can complete the form, but they cannot accidentally overwrite its formula.

Protection applies to a worksheet, not just to the cells you select when you turn it on. The Locked and Hidden properties determine which cells are restricted or concealed under protection. You can also choose whether users may select locked cells, format cells, insert rows, sort, and perform certain other actions.

Unlock the cells users need to edit

Before protecting a sheet, decide which cells should remain editable. In a new workbook, the usual approach is to unlock the intended input cells first; the rest can stay locked. If you protect the sheet before doing this, you may prevent users from filling in every cell.

  1. Select the input cells, such as B2:B20. To select separate areas, hold Ctrl while selecting each range on Windows.
  2. Open the Format Cells dialog with Ctrl+1, then select the Protection tab.
  3. Clear the Locked checkbox and select OK. This changes the cell setting but does not yet protect the worksheet.
  4. Repeat for any other areas that should accept edits, such as a notes field or a date-entry column.

You can also use Home > Format > Lock Cell to toggle the Locked setting for selected cells. The dialog is useful when you want to confirm the setting explicitly. On a Mac, use Command+1 to open Format Cells; menu wording and ribbon layout can vary slightly by Excel release.

Consider entering a test value in each intended input area before sharing the file, then protect the sheet and check that the entry works. Leave formula cells, headings, and instructions locked unless there is a specific reason users should change them. A clear visual cue, such as a fill color on input cells, helps people understand where to type, although color is only a design aid and does not enforce protection.

Protect the worksheet in Excel for Windows

Once the cell settings are ready, protect the sheet:

  1. Open the worksheet you want to protect.
  2. Choose Review > Protect Sheet.
  3. In the dialog, optionally enter a password to unprotect the sheet later.
  4. Review the permissions list. Keep the actions users should not perform unchecked, and allow only the actions needed for their task.
  5. Select OK. If you entered a password, Excel asks you to enter it again to confirm.

Protection takes effect on that worksheet. If a workbook has several sheets, protect each sheet separately as needed. Protecting one sheet does not automatically protect the others, and it does not stop someone from adding, deleting, moving, or renaming sheets unless you also protect the workbook’s structure.

You do not have to set a password to turn on worksheet protection. Without one, a user can generally turn protection off through the Review tab without supplying a password. A password adds a barrier against casual changes, but it should not be treated as strong information security.

Choose the permissions that fit the task

The Protect Sheet dialog offers a set of actions that may be permitted while the sheet is protected. The choices can include selecting locked or unlocked cells, formatting cells, rows or columns, inserting or deleting rows and columns, sorting, using AutoFilter, and using PivotTable reports. Available actions depend on the Excel version and worksheet features.

Allowing an action does not necessarily make every operation possible. For example, sorting a protected range can be restricted when the range contains locked cells, even if sorting is allowed in the protection options. Similarly, users may encounter limits when filtering a range if they cannot select the relevant cells. The safest policy is to grant the minimum permissions needed, then test the actual workflow with protection enabled.

For a simple form, a sensible setup might allow selection of unlocked cells while leaving formatting, row insertion, and deletion disabled. If users need to filter a table, enable the relevant filtering permission and check that the table behaves as expected. Avoid enabling every option just in case: unnecessary permissions make it easier for someone to alter the sheet’s layout or structure accidentally.

Hide formulas and protect workbook structure

Locking a formula cell prevents ordinary edits while the sheet is protected, but it does not hide the formula from someone who selects the cell. To hide a formula from the formula bar, select its cell, open Format Cells with Ctrl+1, and on the Protection tab select Hidden as well as Locked. Then protect the worksheet. The Hidden setting only takes effect while the sheet is protected.

Hiding a formula is not the same as encrypting or securing the underlying calculation. Worksheet protection is designed primarily to prevent accidental or casual changes. It should not be used to protect sensitive business information, personal data, or intellectual property from a determined recipient.

To restrict changes to sheet names, order, or sheet creation and deletion, use workbook-structure protection separately. In Excel for Windows, choose Review > Protect Workbook and select the structure option in the dialog. This is distinct from protecting individual worksheets. If the goal is to keep people from opening the file without authorization, use file encryption instead, such as File > Info > Protect Workbook > Encrypt with Password. Keep any password in a secure place; losing it can prevent access or changes, depending on which protection was applied.

Allow editing in selected ranges

Sometimes a sheet needs more than one level of access. Excel for Windows includes an Allow Edit Ranges feature, available from Review > Allow Edit Ranges, that can define ranges users may edit on a protected worksheet. Depending on the workbook environment and permissions, a range can be configured with a password or access for specified users. This can be useful when different people are responsible for different sections of a shared planning sheet.

Set up the editable ranges before protecting the sheet, and check the options in your version of Excel because some access features depend on the Windows edition, domain, or organizational setup. Range permissions do not replace a careful test: protect the worksheet and verify that the intended users can edit their area while other locked cells remain unavailable. For a straightforward form where everyone edits the same fields, simply unlocking those cells is usually easier to maintain.

Excel for the web, Mac, and collaboration

Excel for the web supports worksheet protection, but its controls and dialog layout can differ from the Windows desktop version. Open the Review tab and look for the sheet-protection controls; the available permission settings may not match the full Windows dialog. If you need detailed configuration, such as particular allowed actions or range-based access, open the workbook in the desktop app and review the options there.

Excel for Mac also has worksheet protection under the Review tab, though ribbon placement and dialog wording can vary between releases. The key process is the same: set the cell protection properties, protect the sheet, and choose the actions users may perform. The common shortcut for Format Cells is Command+1 on Mac rather than Ctrl+1 on Windows.

Protection does not prevent collaborators from viewing the workbook or guarantee that edits are tracked or recoverable. For shared files, use OneDrive or SharePoint collaboration and version history where appropriate, and coordinate who owns the protected layout. A protected worksheet can still be a useful guardrail, but it is not a substitute for access controls, backups, or clear sharing permissions.

Common problems and fixes

  • No cells can be edited: The input cells may still be marked Locked. Unprotect the sheet, select those cells, clear Locked in Format Cells, and protect the sheet again.
  • Users can edit cells that should be fixed: Those cells may have been unlocked, or sheet protection may have been turned off. Check the cell settings and confirm protection is active.
  • A formula is visible: Locked does not mean hidden. Set the Hidden property for formula cells and protect the sheet again.
  • A user cannot sort or filter: Review the allowed actions and test the operation on the protected sheet. The range’s locked cells and layout can affect whether Excel permits it.
  • The password is unavailable: Excel does not provide a normal password-recovery button for worksheet protection. Ask the workbook owner or your organization’s administrator before making changes, and keep a separate authorized copy when setting up protection.

Before distributing a protected template, test it as a user would: try entering data in each input area, attempt to change a formula, and use any allowed sorting or filtering. This catches setup errors before they disrupt someone else’s work.

Frequently Asked Questions

How do I protect only certain cells in Excel?
Unlock the cells people may edit, leave the other cells locked, and then protect the worksheet. Protection applies to the sheet, while each cell’s Locked setting determines whether it can be changed.

Are Excel cells locked by default?
Cells are generally marked as locked by default. They become restricted only after worksheet protection is enabled, which is why you usually unlock input cells before protecting the sheet.

Can I protect a sheet without a password?
Yes. In the Protect Sheet dialog, leave the password field blank and confirm the settings. This prevents edits to locked cells while protection is on, but it offers little resistance to someone who deliberately turns protection off.

Does protecting a sheet stop people from seeing data?
No. Worksheet protection is not a confidentiality feature. It restricts specified edits, but it does not encrypt the workbook or reliably prevent users from viewing or copying its contents.

How do I remove sheet protection?
In desktop Excel, choose Review > Unprotect Sheet. If a password was set, enter it when prompted. If you do not know the password, contact the workbook owner or your organization’s administrator.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.