Protect Specific Columns from Selected Users in Excel Online
Question details
The user needs to prevent selected users from editing specific columns while allowing them to edit other parts of an Excel Online workbook.
- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- A shared workbook needs different editing restrictions for different users or groups.
- Observed behavior
- Excel Online sharing permissions apply to the entire workbook, while worksheet protection locks cells for all users rather than assigning permissions by individual email address.
Decide which cells should remain editable and which cells must be locked before protecting the worksheet. To configure locked and unlocked cells, open the workbook in the desktop Excel app rather than Excel for the web.
Use desktop Excel to lock restricted columns and protect the worksheet
Use this method when all workbook editors should be blocked from changing the same restricted columns.
Excel Online does not provide Google Sheets-style, email-based permissions for individual columns or cells. Worksheet protection can still prevent users from editing locked columns after the workbook is configured in desktop Excel.
In Excel Online, select Editing or Open in Desktop App to open the workbook in the desktop version of Excel.
Select the cells or columns that collaborators should be able to change, then choose Home > Format > Format Cells > Protection and clear the Locked checkbox.
Select the columns that must not be edited, open Format Cells > Protection, and ensure Locked is selected.
Go to Review > Protect Sheet, choose the actions users can perform, optionally set a password, and select OK.
Save the protected workbook to OneDrive or SharePoint so collaborators open the updated protected version in Excel Online.
Control workbook-level access through OneDrive or SharePoint sharing
Use this method to decide who can edit the whole workbook and who can only view it.
Use separate workbooks or a granular-access system for role-based editing
Use this approach when different people must edit different data fields and worksheet protection is not sufficient.
Use WPS Office for familiar spreadsheet editing and worksheet protection
WPS Office is a free, lightweight Office alternative for users who need a familiar spreadsheet workspace and standard worksheet protection. It does not provide email-based permissions for individual columns, so use a dedicated role-based platform when granular user access is required; WPS Office can help you continue working with compatible Excel files during migration.
Frequently Asked Questions
Can Excel Online lock only certain columns?
Yes. Configure the columns as locked in desktop Excel, unlock the cells that should remain editable, and then use Review > Protect Sheet. The protection is honored when the workbook is opened in Excel Online.
Can I allow one person to edit Column A and another person to edit Column B in Excel Online?
No. Excel Online does not support individual email-based editing permissions for specific columns or cells. Workbook sharing applies to the file, and sheet protection applies to locked cells for all users.
Why can users still edit protected columns after I locked them?
Locked status has no effect until worksheet protection is enabled. In desktop Excel, go to Review > Protect Sheet after setting the Locked option in Format Cells > Protection.
Can OneDrive sharing settings restrict access to a specific worksheet or column?
No. OneDrive and SharePoint Manage access and Share settings control view or edit access for the workbook file, not for individual worksheets, columns, or cells.
Does VBA create per-user column permissions in Excel for the web?
No. Excel for the web does not support running VBA macros. For user-specific field permissions, use separate files or a platform such as Microsoft Lists, SharePoint, or Power Apps.
