How to Allow Excel Comments While Protecting Worksheet Data
Question details
The user needs to protect a shared Excel workbook to prevent accidental or unauthorized data changes while still allowing collaborators to add cell comments.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Sharing a workbook stored on SharePoint across multiple departments where users need to leave feedback via comments without altering the actual cell values.
- Observed behavior
- The goal state is to have a protected worksheet where cell data is locked from editing, but the ability to insert comments is explicitly permitted.
Ensure you are editing the workbook using the desktop version of Excel, as web-based versions may lack the advanced permission settings required to allow specific object modifications.
Configure Protect Sheet Settings to Allow Objects
By customizing the Protect Sheet permissions, you can lock cell data while keeping the ability to add and edit objects like comments.
In Excel, comments are treated as 'objects'. When you protect a worksheet, you can specifically grant users the permission to edit objects, which enables them to insert, edit, or delete comments even if the cells themselves are locked.
If your file is stored on SharePoint, open the workbook in the desktop Excel application rather than your web browser to access full protection features.
Click on the 'Review' tab in the top Excel ribbon, then click on 'Protect Sheet'.
In the Protect Sheet dialog box, scroll down the 'Allow all users of this worksheet to' list and check the box for 'Edit objects'. In some Excel versions, you may also see a specific 'Edit scenarios' or 'Insert comments' option to check.
Type an optional password to prevent unauthorized users from removing the protection, click 'OK', re-enter the password to confirm, and click 'OK' again.
Easily Protect Worksheets and Allow Comments in WPS Office
WPS Office offers comprehensive spreadsheet protection features that mirror Microsoft Excel. You can effortlessly secure your data while enabling teamwork through comments using this free, highly compatible alternative.
- 1. Open your Spreadsheet: Launch WPS Spreadsheets and open your shared .xlsx workbook.
- 2. Go to the Review Tab: Navigate to the 'Review' tab located in the top menu ribbon.
- 3. Select Protect Sheet: Click the 'Protect Sheet' button to open the protection settings window.
- 4. Enable Object Editing: In the options list, check 'Edit objects' to ensure users are permitted to insert and modify comments.
- 5. Confirm Protection: Enter a secure password and click 'OK' to lock the spreadsheet data.
Frequently Asked Questions
Why can't users add comments even after I protected the sheet?
If users cannot add comments, it is likely because the 'Edit objects' permission was left unchecked during the protection process. Unprotect the sheet, click Protect Sheet again, and ensure 'Edit objects' is selected.
Can I configure these comment permissions in Excel Online?
Excel Online offers limited worksheet protection settings. To access the detailed permissions checklist (including allowing object editing), you must open the workbook in the desktop Excel application.
How do I completely remove the worksheet protection later?
To remove the protection and allow standard data editing, go to the 'Review' tab and click 'Unprotect Sheet'. If a password was originally set, you will be prompted to enter it.
