File Sharing Problems

Can View-Only Users Comment on an Excel Worksheet?

Nimra MalikNimra Malik Oct 14, 2026 869 views

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.

How to Allow View-Only Users to Comment in Excel
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 you start

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.

Solution 1Recommended

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.

1
Lock All Cells

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.

2
Protect the Worksheet

Go to the 'Review' tab on the Excel ribbon and click 'Protect Sheet'.

3
Allow Object Editing

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.

4
Set a Password and Share

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.

Use Worksheet Protection to Allow Comments but Prevent Cell Edits
Important Security Note: Checking 'Edit objects' also allows users to insert, move, or delete other objects like shapes and charts. Keep this in mind if your worksheet relies heavily on visual graphics.
Free Microsoft Office alternative

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. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your device.
  2. 2. Open Your Excel File: Double-click your existing .xlsx file to open it seamlessly in WPS Spreadsheet.
  3. 3. Apply Protection: Use the comprehensive 'Protect Sheet' features found in the Review tab to control exactly what collaborators can do.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) with zero formatting loss.Robust document encryption and detailed sheet protection features to secure your sensitive data.Free, lightweight, and fast alternative featuring a familiar, intuitive user interface.Cloud-based collaboration tools that strictly respect your privacy and business data policies.
microsoft office alternative - wps office

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.