Can View-Only Users Comment on an Excel Worksheet?
Question details
The user wants to allow viewers to add comments to an Excel workbook without giving them the ability to edit the actual cell data.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sharing an Excel file to collect feedback from colleagues or clients while ensuring sensitive data remains unaltered and secure.
- Observed behavior
- Native Excel sharing permissions lack a specific 'Comment-only' role, meaning users either get view-only access (no comments) or full edit access.
Before making changes, verify that your workbook is saved to OneDrive or SharePoint if you plan to share it online, and consider creating a backup copy of your sensitive data.
Use Worksheet Protection to Allow Comments but Prevent Cell Edits
Since Excel lacks a direct 'Comment-only' sharing link, you can simulate this by locking all cells and protecting the worksheet, while allowing users to edit objects (which includes comments).
By applying worksheet protection and selectively allowing object editing, you can grant users Edit access to the file while mathematically locking down your actual cell values. This ensures they can leave comments but cannot change your data.
Select all cells in your worksheet by pressing Ctrl+A. Right-click anywhere on the sheet, choose 'Format Cells', navigate to the 'Protection' tab, and ensure the 'Locked' box is checked.
Go to the 'Review' tab on the Excel ribbon and click 'Protect Sheet'.
In the protection dialog box, scroll down the list of 'Allow all users of this worksheet to:' and check the box for 'Edit objects'. This is the setting that permits users to add and edit comments.
Enter a secure password to prevent unauthorized users from removing the protection, and click 'OK'. You can now share the file with 'Edit' permissions; users will only be able to interact with comments.

Collect Feedback via a Separate Workbook or Form
If worksheet protection is too complex or does not meet strict security policies, use external tools to gather input without risking the original file.
Try WPS Office for Secure, Privacy-Focused Spreadsheet Management
Frustrated by Excel's permission limitations but cannot use Google Sheets due to privacy or business policies? WPS Office offers a powerful, secure, and free alternative to Microsoft Office. With WPS Spreadsheet, you get advanced sheet protection, a familiar interface, and uncompromising format compatibility.
- 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Excel File: Double-click your existing .xlsx file to open it seamlessly in WPS Spreadsheet.
- 3. Apply Protection: Use the comprehensive 'Protect Sheet' features found in the Review tab to control exactly what collaborators can do.

Frequently Asked Questions
Will Microsoft add a Comment-only permission level to Excel?
Currently, Microsoft Excel does not have a native 'Commenter' permission link for shared files. Users are encouraged to submit feature requests through the Microsoft Excel feedback portal, as the product team often considers highly requested features for future updates.
Can I hide comments from other view-only users in Excel?
Standard Excel comments and notes are visible to anyone who has access to view the document. If feedback must remain confidential between you and the commenter, using a private external form or survey tool is recommended instead of native comments.
Why does Google Sheets have this feature but Excel does not?
Different software platforms prioritize different collaboration architectures. While Google Sheets was built from the ground up for browser-based sharing (including a native 'Commenter' role), Excel's permissions have historically focused on file-level 'Read' or 'Write' access, though Microsoft continuously updates its Microsoft 365 cloud features.




