Edit ranges let specific people change only the cells you choose, while the rest of the sheet stays locked

An edit range in Excel for Mac is a section of your spreadsheet that you unlock and assign to one person or a group. Everyone else sees the sheet but cannot change anything in that range — they can only view it. This is useful when you share a budget spreadsheet with your team and want the accountant to update numbers in one column while preventing anyone else from accidentally deleting formulas or changing totals.

The process has three steps: you create the range, you protect the sheet, and you tell Excel who gets to edit that range. The person you assign needs a Microsoft account, and they edit the file either in Excel on their Mac or in Excel online.

Key Takeaways

  • Edit ranges work only when you protect the sheet afterward — without protection, the range setting does nothing.
  • The person editing the range must have a Microsoft account and either Excel for Mac or access to Excel online.
  • You can create multiple ranges and assign each one to a different person or group.
  • Once you protect the sheet, you can still edit any cell yourself, but others can only change cells in their assigned ranges.

How to create and assign an edit range

Open your spreadsheet in Excel for Mac. Select the cells you want to allow editing in — for example, cells B2 through B50 where your team enters monthly expenses. Click the Review tab at the top of the screen, then find Allow Edit Ranges (it may appear as a button or in a dropdown menu depending on your Excel version).

A dialog box opens. Type a name for this range — something like "Monthly Expenses" or "Q1 Budget" so you remember what it covers. Then click the button to specify who can edit it. Enter the Microsoft email address or the name of the person or group. If you want multiple people to edit the same range, add each email address. Click OK when you are done.

Repeat this process for any other ranges you want to create. You might have one range for the sales team, another for the finance team, and a third for the manager to review totals.

Protecting the sheet so edit ranges take effect

Creating a range does nothing until you protect the sheet. Go back to the Review tab and click Protect Sheet. A dialog appears asking what you want to allow people to do — usually you leave these settings as they are (most boxes stay unchecked). Click OK.

Excel may ask you to set a password. You do not have to — you can leave it blank and click OK again. The sheet is now protected. Anyone who is not assigned to an edit range will see a message saying "This cell is protected and read-only" if they try to click on a locked cell.

What happens when someone tries to edit a cell they are not assigned to

If a team member tries to change a cell outside their edit range, Excel shows a message: "The cell you are trying to change is protected." They cannot proceed. This prevents accidental changes and keeps your formulas and totals safe.

The person assigned to an edit range can click and type in those cells normally. They do not see any warning or extra steps — it works like editing an unprotected sheet.

Editing or removing an edit range later

If you need to change who can edit a range or adjust which cells are included, you must unprotect the sheet first. Go to Review and click Unprotect Sheet (you may need to enter the password if you set one). Then go back to Allow Edit Ranges, select the range you want to change, and click Edit or Delete. Make your changes and protect the sheet again.

This is why naming your ranges clearly matters — if you have five ranges and need to find the one for the sales team, a name like "Sales Team Q1" is much faster to spot than "Range 1" or "Data".

When edit ranges work best and when they do not

Edit ranges work well for shared budgets, sign-up sheets, and data entry forms where you want to control exactly which cells change. They are less useful if you need to track who changed what and when — edit ranges do not create a change log. For that, you would use Track Changes (also in the Review tab) or keep the file in OneDrive and check the version history.

Edit ranges also assume everyone is working in Excel for Mac or Excel online. If someone opens the file in Google Sheets or a different program, the protection may not carry over. For maximum compatibility, keep the file in .xlsx format and ask your team to use Excel.

Frequently Asked Questions

Can I create an edit range for a group instead of one person?

Yes. When you assign the range, enter a Microsoft 365 group email address instead of an individual email. Everyone in that group can then edit the range. This is faster than adding each person one at a time.

What if I forget the password I set when protecting the sheet?

You cannot unprotect the sheet without the password. You would need to copy the data to a new sheet and set it up again. This is why many people choose not to set a password — the protection still works, and you can unprotect it anytime.

Do edit ranges work if someone opens the file in Excel online instead of Excel for Mac?

Yes. Edit ranges work the same way in Excel online. The person assigned to a range can edit it, and everyone else sees locked cells. The file must be stored in OneDrive or SharePoint for online editing to work.

Can I see which cells someone edited in their assigned range?

Edit ranges do not show you who changed what. If you need that information, turn on Track Changes in the Review tab before sharing the file. This records every edit with the person's name and timestamp.

What happens if I delete an edit range but forget to unprotect the sheet first?

You cannot delete it while the sheet is protected. Excel will ask you to unprotect the sheet first. Unprotect it, delete or edit the range, then protect it again.