How to Protect Specific Excel Cells in a Shared OneDrive Workbook
Question details
The user needs to restrict editing in a shared Excel workbook stored on OneDrive so that only specific cells or ranges can be changed.

- Product
- WPS Office Spreadsheets and Microsoft OneDrive
- Device & OS
- not provided
- Scenario
- A user shares an Excel workbook through OneDrive and needs to control which users can edit specific ranges.
- Observed behavior
- Excel for the web does not provide range-level cell protection controls, and shared links do not restrict editing to a selected range.
Open the workbook in the WPS Office desktop application because cell protection must be configured before the file is uploaded. Confirm which cells should remain editable and which should stay locked.
Protect specific cells in WPS Office before uploading to OneDrive
Use this method when you want to lock most of a sheet while allowing edits only in selected cells, and you plan to share the workbook from OneDrive.
WPS Office Spreadsheets saves workbooks in the standard .xlsx format. When you protect the worksheet before uploading, Excel for the web keeps the locked cells protected and still allows edits to the cells you unlocked.
Launch WPS Office on your computer, click Open, and select the Excel workbook you want to protect.
Select the specific cells or range, right-click and choose Format Cells > Protection. Uncheck Locked, then click OK. Leave all other cells locked.
Go to the Review tab, click Protect Sheet, enter a password, choose the actions you want to allow, and click OK.
Save the file as .xlsx, upload it to OneDrive, and share it. The locked cells remain protected when the workbook is opened in Excel for the web.

Use Excel desktop Allow Edit Ranges for user-level permissions
Choose this if you need Active Directory-based user permissions for different ranges instead of one shared password.
Protect Specific Excel Cells Before Uploading to OneDrive with WPS Office
Use WPS Office Spreadsheets to lock individual cells and protect the worksheet, then upload the .xlsx file to OneDrive. The protection remains active in Excel for the web while keeping the familiar .xlsx format.
- 1. Open your workbook in WPS Office: Launch WPS Office Spreadsheets and open the .xlsx file you want to protect.
- 2. Unlock editable cells: Select the cells users may edit, right-click > Format Cells > Protection, and uncheck Locked.
- 3. Protect the sheet: Click Review > Protect Sheet, set a password, and confirm the allowed actions.
- 4. Save and upload to OneDrive: Save the .xlsx file, upload it to OneDrive, and share the link.

Frequently Asked Questions
Can I lock specific cells in Excel for the web?
No. Excel for the web does not currently provide range-level cell locking controls. You need to configure cell protection in the Excel desktop app or WPS Office Spreadsheets, then upload the workbook to OneDrive.
Will WPS Office sheet protection remain active when I open the workbook in OneDrive?
Yes. When you save the protected workbook as .xlsx and upload it to OneDrive, Excel for the web keeps locked cells protected. Users can still edit cells that you unlocked before protecting the sheet.
Does a OneDrive shared link restrict editing to a selected range?
No. A shared link to a workbook section can outline the shared area, but it does not prevent users from editing outside that area. Range-level editing restrictions must be set through sheet protection in a desktop application.
How do I unlock only certain cells so users can edit them?
Select the cells you want to allow users to edit, right-click and choose Format Cells > Protection, then uncheck Locked. After that, go to Review > Protect Sheet to enforce locking on all other cells.
Do I need a Microsoft 365 subscription to protect specific cells?
No. WPS Office Spreadsheets can open, protect, and save .xlsx workbooks without a Microsoft 365 subscription. You only need a OneDrive account if you want to share the protected file online.




