Excel Protect Sheet Except for Selected Users: How It Works

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, use Review > Allow Edit Ranges to designate cells and, where your Windows environment supports it, grant specific users or groups permission to edit them; then protect the sheet. For a simpler alternative, give a range a password and share it with the people who need access—but that does not verify who they are.

What “selected users” means in Excel

Excel offers two different ways to make exceptions to worksheet protection. One uses Windows user or group permissions to identify who may edit a particular range. The other lets anyone who knows a range password edit it. Both approaches are configured through Allow Edit Ranges, but they provide different kinds of control: a password is shared knowledge, while a user permission is tied to an account recognized by Windows.

These exceptions matter only when the worksheet is protected. Excel cells are marked as locked by default, but that setting does not prevent editing until you turn on sheet protection. Once protection is active, most locked cells cannot be changed, while unlocked cells and ranges granted an exception remain editable according to the options you set.

“Selected users” also does not mean that Excel can keep the workbook secret from everyone else who can open it. Worksheet protection is mainly a way to limit changes, not a strong confidentiality or file-access barrier. Use OneDrive, SharePoint, or file encryption and access controls when people should not be able to open or read the workbook at all.

Set up a user-specific editable range

For named users, create the permitted range before protecting the worksheet. In Excel for Microsoft 365 on Windows, use these steps:

  1. Open the worksheet and select the cells the permitted users should be able to change. For example, select D5:D20 if those are the input cells in a form.
  2. Choose Review > Allow Edit Ranges. In the dialog, choose New.
  3. Enter a descriptive title and check the cell reference in the range field. If you selected cells first, Excel normally fills in the reference; correct it if necessary.
  4. Choose Permissions, then add the Windows user accounts or groups that should be allowed to edit this range. Follow the dialog to select the accounts available in your organization.
  5. Confirm the range settings, then choose Review > Protect Sheet. Set a sheet-protection password if appropriate and choose which actions users may perform while the sheet is protected.
  6. Save the workbook, then test it with an account that should have access and one that should not. Do not assume that a successful test while signed in as the workbook creator proves that the permissions work for everyone.

The Permissions option for assigning Windows identities depends on the computer and organization’s account environment; it may not be available in every setup. In particular, the classic user-permission workflow relies on supported Windows account or domain permissions. If the button is missing or the intended users cannot be resolved, check with your Microsoft 365 or Windows administrator rather than treating a range password as equivalent identity verification.

How range passwords differ from user permissions

If you do not need account-based access, create a range with a password in the Allow Edit Ranges dialog instead. Users who enter that password can edit the range after the sheet is protected. This can be convenient for a small team or a workbook passed between people, but anyone who learns or receives the password can use it. Excel does not use that shared password to distinguish one person from another.

A range password and a sheet-protection password are separate settings. The range password opens an exception for the specified cells; the sheet password controls changing the worksheet’s protection state and settings. If you set both, record them securely and explain which one users need. Giving a user only the sheet password is not the same as giving them permission for a specific range.

It is possible to leave the range password blank when relying on user permissions, or to use a range password when identity-based permissions are not available. Avoid creating several overlapping ranges with different rules unless there is a clear reason: overlapping exceptions can make it harder to understand which users are meant to edit which cells. A short, named list of non-overlapping input ranges is easier to maintain.

Choose between unlocked cells and named ranges

For a workbook where every user may edit the same input cells, unlocking those cells is usually simpler than assigning individual permissions. Select the cells, open Home > Format > Format Cells, go to the Protection tab, clear Locked, and confirm. Then protect the sheet. Those unlocked cells can be edited by anyone who can edit the protected worksheet, so this method does not single out named people.

Use Allow Edit Ranges when different people should have different editable areas, or when you want to keep cells locked but create specific exceptions. For example, a planning workbook might have a protected assumptions area and a separate input range for each department. If each department uses a different Windows group and the environment supports range permissions, assign each group to its own range. If all departments may edit the same inputs, unlocking those inputs is less complicated.

Before applying protection, map the worksheet’s intended use. A practical setup might include:

  • Locked formulas and headings that ordinary users should not change.
  • Unlocked cells for information that every workbook user may enter.
  • Named, protected ranges for cells reserved for particular users or teams.
  • Clear labels or fill colors that tell users where they are expected to type.

Protection is easier to operate when the sheet communicates what is editable. Consider testing ordinary tasks too: filtering a table, sorting, inserting rows, or formatting cells may be blocked unless you permit the relevant actions in the Protect Sheet dialog. Allow only the actions users genuinely need.

What sheet protection does—and does not—secure

Protect Sheet is designed to prevent accidental or routine changes to locked cells and worksheet features. It is useful for distributing a template with formulas, labels, or carefully arranged sections that users should leave intact. It is not a substitute for controlling who can open the file, and it should not be relied on to protect sensitive information against a determined recipient.

Someone who can open a workbook may be able to copy information from it, and worksheet protection is not the same as encrypting the workbook with a password required to open it. If the content itself must be restricted, control file access through the storage location and use Excel’s file-encryption options where appropriate. In a work or school environment, follow the organization’s information-protection policies.

Also distinguish worksheet protection from workbook-structure protection. Protecting a sheet governs changes to that worksheet; protecting workbook structure limits actions such as adding, deleting, moving, or renaming sheets. Neither setting decides who is allowed to open the file. Choose each control for the problem it actually addresses.

Windows, Mac, and Excel for the web

The steps above target Excel for Microsoft 365 on Windows, where the Allow Edit Ranges dialog provides the classic setup for range passwords and, in supported environments, Windows user permissions. Menu availability can vary with the Excel build, account setup, and organization policies. If a command is absent, confirm that you are using the desktop app and ask your administrator whether the required account-permission feature is supported.

Excel for Mac supports worksheet protection and the basic idea of locking or unlocking cells, but the Windows-specific user and group permission workflow is not available in the same way. Use a supported Windows desktop installation to configure and administer those permissions, then verify the workbook in the environment where it will be used. Keyboard shortcuts differ: Ctrl+1 opens Format Cells on Windows, while Command+1 is the corresponding shortcut on Mac.

Excel for the web is useful for viewing and editing many workbooks, but it does not provide the full Windows desktop workflow for configuring Allow Edit Ranges permissions. If you need to create or change named-user exceptions, open the workbook in desktop Excel on Windows. When people collaborate through OneDrive or SharePoint, test the protected workbook with the actual sharing and editing arrangement; file-sharing permissions and worksheet permissions operate at different levels.

Common problems and how to fix them

  • Everyone can edit the cells. Check that Protect Sheet is on. Locked status alone does not enforce anything. Also confirm that the cells are not unlocked or covered by a range exception.
  • An authorized person still cannot edit. Confirm the exact cell reference, the account or group assigned, and that the person is signed in under the expected Windows identity. Check whether the worksheet is protected and test the user’s access in the same desktop or shared-file context they will use.
  • The Permissions button is unavailable. The user-based option depends on supported Windows account infrastructure. Use the available range-password option only if sharing a password is acceptable, or ask an administrator about a different access-control design.
  • Users can edit cells but cannot sort or filter. Those actions are separate sheet-protection permissions. Unprotect the sheet, adjust the permitted actions in Protect Sheet, and test the workflow again.
  • A user can open the file but should not see its contents. Sheet protection is the wrong control for that requirement. Restrict access to the workbook itself through the storage or file-protection system.

When changing an existing workbook, make a backup first and document the range names, users or groups, and passwords. If staff accounts change, review the permissions; a range rule is only useful while it names the intended people or groups. A small test sheet can help you confirm the setup before applying the same approach to a business-critical workbook.

Frequently Asked Questions

Can I let only one person edit certain cells in Excel?
Yes, if your Windows account environment supports user-specific permissions in Allow Edit Ranges. Add that person’s account to the range, protect the sheet, and test using their account. If you use a range password instead, anyone who knows it may edit those cells.

Can different users edit different ranges?
Yes. Define separate ranges and assign the appropriate users or groups to each one, then protect the worksheet. Keep the ranges distinct where possible and test that each user can edit only the intended cells.

Does protecting a sheet stop people from copying the workbook?
No. Sheet protection limits certain changes within a worksheet; it does not prevent someone who can access the file from opening or copying it. Use file access controls or encryption when the goal is to restrict access to the workbook’s contents.

Can I set this up in Excel for the web or on a Mac?
You can use sheet protection and unlocked cells in other Excel editions, but the Windows desktop app is the intended place to configure the classic named-user range permissions. Use Windows Excel for that setup and verify the result in your users’ actual editing environment.

What if I only need everyone to edit the same input cells?
Unlock those cells in Format Cells, then protect the worksheet. This is simpler than assigning user permissions, but it allows every person who can edit the sheet to change those cells.

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.