Limit Editing to Specific Excel Cell Ranges in Microsoft Teams
Question details
The user wants to allow a Teams user to edit only selected ranges in a shared Excel workbook.

- Product
- Microsoft Excel and Microsoft Teams
- Device & OS
- not provided
- Scenario
- A workbook stored in Teams needs restricted worksheet editing for a shared user.
- Observed behavior
- The Allow Edit Ranges dialog does not accept the Teams users shown in the workbook sharing interface.
Open the workbook from Teams in the desktop Excel app and confirm that you can edit it. Identify the cells that should remain editable and check the workbook's sharing permissions.
Protect the Excel worksheet and unlock permitted cells
Use worksheet protection to restrict editing to selected cells for everyone who has edit access to the workbook.
This method does not assign different editable ranges to individual Teams users. All users with edit access can edit the unlocked cells.
Excel's Allow Edit Ranges permissions use supported Windows or Active Directory accounts, not arbitrary Microsoft 365 or Teams sharing identities.
In Teams, locate the workbook, select its More options menu, and choose to open it in the desktop Excel app.
Select the entire worksheet, right-click, and choose Format Cells. On the Protection tab, select Locked and click OK.
Select the cells users may edit, then right-click and choose Format Cells. On the Protection tab, clear Locked and click OK.
Select Review > Protect Sheet, choose the actions users may perform, and set a password if needed. Confirm the protection settings.
Save the workbook and allow it to sync to Teams. Use Share to confirm the intended user has edit access, then test an unlocked cell and a locked cell.

Edit Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files to make migration easier; WPS does not fix Microsoft Teams range-permission limitations.

Frequently Asked Questions
Why can't I add a Teams user in Allow Edit Ranges?
The Excel dialog uses supported Windows or Active Directory accounts and groups, not arbitrary Microsoft 365 identities shown in the Teams sharing interface.
Does unlocking a range allow only one Teams user to edit it?
No. After you use Review > Protect Sheet, the unlocked range is editable by anyone who has edit access to the workbook. It is not restricted to one Teams user.
Can a user edit unlocked cells without workbook edit access?
No. The user also needs edit permission for the workbook. Check the file's Share settings in Teams or Excel.
Does protecting a worksheet secure confidential data?
No. Worksheet protection is intended to prevent unwanted changes, not to secure confidential data. Use the file's sharing permissions to control access.




