Comments and suggestions in Google Sheets - Deep Dive

Overview - Comments and suggestions

What is it?

Comments and suggestions in Google Sheets let you add notes or ideas to specific cells without changing the actual data. Comments are like sticky notes for conversations, while suggestions let others propose changes that can be accepted or rejected. They help teams work together smoothly by sharing thoughts directly on the spreadsheet.

Why it matters

Without comments and suggestions, collaborating on spreadsheets would be confusing and slow. People would have to explain changes separately or risk overwriting each other's work. These features keep communication clear and organized right where the data lives, saving time and avoiding mistakes.

Where it fits

Before learning comments and suggestions, you should know basic Google Sheets navigation and how to enter data. After mastering these, you can explore advanced collaboration tools like version history and protected ranges to control editing.

Mental Model

Core Idea

Comments and suggestions are conversation tools built into cells that let people share feedback and propose changes without altering the original data until approved.

Think of it like...

Imagine a shared notebook where friends write notes in the margins (comments) and suggest edits in pencil (suggestions) that others can accept or erase later.

┌───────────────┐
│   Cell Data   │
│───────────────│
│  Original     │
│  Value        │
├───────────────┤
│ Comments 💬   │ ← Notes attached to cell
│ Suggestions ✏ │ ← Proposed edits
└───────────────┘

Build-Up - 6 Steps

1

Foundation

Adding basic comments to cells

Concept: Learn how to insert a comment attached to a cell to share notes or questions.

To add a comment, right-click a cell and choose 'Comment'. Type your message and click 'Comment' to save. A small orange triangle appears in the cell corner, showing a comment is there. Hover over the cell to read it.

Result

The cell shows a small orange triangle, and the comment appears when you hover or click the cell.

Knowing how to add comments lets you communicate directly on data points without changing the numbers or text.

2

Foundation

Viewing and replying to comments

Concept: Understand how to read comments and reply to create a conversation thread.

Click the cell with a comment to open it. You can read the original note and add your reply below. This creates a conversation visible to everyone with access. You can also resolve comments to mark them done.

Result

Comments become discussion threads attached to cells, helping teams clarify or debate data points.

Using replies turns simple notes into collaborative conversations, improving teamwork and clarity.

3

Intermediate

Making and managing suggestions

🤔Before reading on: do you think suggestions immediately change the cell data or wait for approval? Commit to your answer.

Concept: Learn how to propose changes as suggestions that others can accept or reject.

Turn on 'Suggesting' mode by clicking the pencil icon in the top-right and selecting 'Suggesting'. Now, when you edit a cell, your changes appear as suggestions in a different color. Others can review and accept or reject these edits.

Result

Suggested changes appear next to original data, not overwriting it until accepted.

Understanding suggestions helps prevent accidental data changes and supports controlled collaboration.

4

Intermediate

Resolving and deleting comments

🤔Before reading on: do you think resolving a comment deletes it permanently or just hides it? Commit to your answer.

Concept: Learn how to mark comments as done and manage comment visibility.

To resolve a comment, open it and click 'Resolve'. This hides the comment from the sheet but keeps it in the comment history. You can also delete comments if you have permission, removing them completely.

Result

Resolved comments disappear from view but can be restored; deleted comments are gone forever.

Knowing how to manage comments keeps your sheet clean and focused while preserving important discussions.

5

Advanced

Using comments and suggestions for workflow

🤔Before reading on: do you think comments and suggestions can be used to assign tasks or just for notes? Commit to your answer.

Concept: Explore how comments and suggestions can organize teamwork and assign responsibilities.

You can mention people in comments using + or @ followed by their email to notify them. This lets you assign tasks or ask questions. Suggestions can be used to propose data corrections or updates that require approval before applying.

Result

Comments become action items and suggestions become controlled edits, improving team workflows.

Using these features as workflow tools turns a spreadsheet into a collaborative project space, not just data storage.

6

Expert

Limitations and best practices for comments

🤔Before reading on: do you think comments can be exported with the sheet data? Commit to your answer.

Concept: Understand the limits of comments and suggestions and how to use them effectively in large projects.

Comments and suggestions do not export with spreadsheet files like Excel or CSV. Overusing comments can clutter sheets and slow performance. Best practice is to resolve or delete old comments and use suggestions for critical changes only.

Result

Knowing these limits helps maintain clean, efficient sheets and clear communication.

Recognizing when and how to use comments prevents collaboration overload and data confusion.

Under the Hood

Comments and suggestions are stored as metadata linked to specific cells, separate from the cell's actual content. When you add a comment, it creates a thread stored in Google Sheets' cloud, visible to collaborators. Suggestions track proposed edits as overlays that do not change the cell value until accepted, preserving original data until approval.

Why designed this way?

Google Sheets was built for real-time collaboration, so comments and suggestions needed to allow communication without disrupting data. Separating notes and proposals from cell content prevents accidental overwrites and supports asynchronous teamwork. This design balances flexibility with data integrity.

┌───────────────┐       ┌───────────────┐
│   Cell Data   │──────▶│  Stored Value │
│ (visible)     │       │ (unchanged)   │
├───────────────┤       └───────────────┘
│ Comments 💬   │
│ (metadata)    │──────▶ Stored separately
│ Suggestions ✏ │
│ (proposed)    │──────▶ Overlay until accepted
└───────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Do suggestions immediately change the cell value for everyone? Commit yes or no.

Common Belief: Suggestions instantly update the cell data for all users as soon as you type them.

Reality: Suggestions only show proposed changes in a different color and do not alter the actual cell value until accepted.

Why it matters: Believing suggestions change data immediately can cause confusion and accidental overwrites if users think edits are final.

Quick: Does resolving a comment delete it forever? Commit yes or no.

Common Belief: Resolving a comment removes it permanently from the sheet.

Reality: Resolving hides the comment from view but keeps it in the comment history for later review or reopening.

Why it matters: Thinking resolved comments are gone can lead to lost context or missed feedback during collaboration.

Quick: Can comments be exported with the spreadsheet data? Commit yes or no.

Common Belief: Comments and suggestions export along with the sheet when downloading as Excel or CSV.

Reality: Comments and suggestions do not export with the data; they remain only in Google Sheets online.

Why it matters: Expecting comments in exported files can cause missed feedback or confusion when sharing offline.

Quick: Can anyone edit or delete comments in a shared sheet? Commit yes or no.

Common Belief: All collaborators can freely edit or delete any comment or suggestion.

Reality: Only users with edit permissions can add, edit, or delete comments and suggestions; viewers cannot.

Why it matters: Misunderstanding permissions can cause accidental loss of important feedback or security issues.

Expert Zone

1

Comments can be linked to specific ranges, not just single cells, allowing broader context discussions.

2

Suggestions track changes with user identity and timestamp, enabling audit trails for edits.

3

Mentioning users in comments triggers email notifications, integrating spreadsheet collaboration with communication tools.

When NOT to use

Avoid using comments and suggestions for highly sensitive data or when strict audit trails are required; instead, use protected ranges and version history. For offline collaboration, rely on exported files with manual notes.

Production Patterns

Teams use comments to assign review tasks and clarify data points, while suggestions manage proposed data corrections in financial or inventory sheets before final approval.

Connections

Version Control Systems

Both track proposed changes and allow review before acceptance.

Understanding suggestions in Sheets is like code pull requests, helping manage edits safely in collaborative environments.

Project Management Tools

Comments function like task comments or tickets linked to specific work items.

Using comments as action items in Sheets bridges data work with project workflows, improving team coordination.

Human Conversation Dynamics

Comments and replies mimic threaded conversations, supporting asynchronous dialogue.

Recognizing this helps design clearer communication strategies in digital collaboration.

Common Pitfalls

#1 Adding too many comments without resolving old ones clutters the sheet.

Wrong approach:

Right-click cell → Comment → Add new comment repeatedly without resolving.

Correct approach:

Resolve or delete comments after addressing them to keep the sheet clean.

Root cause:

Not understanding that unresolved comments remain visible and distract users.

#2 Editing cells directly instead of using suggesting mode causes accidental data changes.

Wrong approach:

Typing changes in cells while in 'Editing' mode without switching to 'Suggesting'.

Correct approach:

Switch to 'Suggesting' mode before making proposed edits to track changes safely.

Root cause:

Confusing editing modes and not knowing how suggestions protect data integrity.

#3 Expecting comments to appear in exported files leads to missed feedback offline.

Wrong approach:

Downloading sheet as Excel or CSV and assuming comments are included.

Correct approach:

Use Google Sheets online for comment visibility or export comments separately if needed.

Root cause:

Misunderstanding that comments are metadata stored only in Google Sheets cloud.

Key Takeaways

Comments and suggestions let you communicate and propose changes without altering original data immediately.

Comments create conversation threads attached to cells, while suggestions propose edits that require approval.

Using these tools improves teamwork by keeping feedback organized and visible directly on the spreadsheet.

Understanding permissions and modes prevents accidental data loss or confusion during collaboration.

Managing comments and suggestions well keeps your sheet clean, efficient, and easy to work with.

Practice

1. What is the main purpose of adding comments in Google Sheets?

easy

A. To change the value of a cell automatically

B. To explain or ask questions about specific cells without changing data

C. To format cells with colors and fonts

D. To create formulas that calculate data

Solution

1. Step 1: Understand the role of comments

   Comments are used to communicate information or questions about a cell without altering its content.

2. Step 2: Differentiate comments from other features

   Formatting and formulas change appearance or data, but comments only add notes visible on hover or in a sidebar.

3. Final Answer:

   To explain or ask questions about specific cells without changing data -> Option B

4. Quick Check:

   Comments = Explain or ask questions [OK]

Hint: Comments explain cells without changing data [OK]

Common Mistakes:

• Thinking comments change cell values
• Confusing comments with formatting
• Using comments to write formulas

2. Which of the following is the correct way to add a comment to a cell in Google Sheets?

easy

A. Use the formula =COMMENT() in the cell

B. Right-click the cell and select 'Insert note'

C. Double-click the cell and type the comment

D. Right-click the cell and select 'Comment'

Solution

1. Step 1: Identify how to add comments

   In Google Sheets, comments are added by right-clicking a cell and choosing 'Comment'.

2. Step 2: Differentiate comments from notes and formulas

   'Insert note' adds a note, not a comment. Double-click edits cell content. =COMMENT() is not a valid formula.

3. Final Answer:

   Right-click the cell and select 'Comment' -> Option D

4. Quick Check:

   Add comment = Right-click + Comment [OK]

Hint: Right-click cell, choose 'Comment' to add comments [OK]

Common Mistakes:

• Choosing 'Insert note' instead of 'Comment'
• Trying to type comment directly in cell
• Using a formula to add comments

3. You see a small orange triangle in the top-right corner of a cell in Google Sheets. What does this indicate?

medium

A. The cell has a formula error

B. The cell contains a comment

C. The cell contains a note

D. The cell is locked for editing

Solution

1. Step 1: Recognize cell indicators

   A small orange triangle in the corner of a cell means there is a note attached to that cell.

2. Step 2: Differentiate notes from comments and errors

   Comments show a speech bubble icon, formula errors show error messages, and locked cells have a lock icon.

3. Final Answer:

   The cell contains a note -> Option C

4. Quick Check:

   Orange triangle = Note [OK]

Hint: Orange triangle means note, not comment [OK]

Common Mistakes:

• Confusing notes with comments
• Thinking orange triangle means error
• Assuming cell is locked

4. A user tries to add a comment but accidentally selects 'Insert note'. What is the main difference they will notice?

medium

A. Notes appear as small orange triangles and show on hover; comments open a sidebar and allow replies

B. Notes change the cell value; comments do not

C. Notes are visible to everyone immediately; comments are private

D. Notes can only be added to text cells; comments only to number cells

Solution

1. Step 1: Understand notes vs comments behavior

   Notes show as small orange triangles and appear when hovering over the cell. Comments open a sidebar and support conversations.

2. Step 2: Identify incorrect options

   Notes do not change cell values, both are visible to collaborators, and both can be added to any cell type.

3. Final Answer:

   Notes appear as small orange triangles and show on hover; comments open a sidebar and allow replies -> Option A

4. Quick Check:

   Notes = orange triangle + hover; Comments = sidebar + replies [OK]

Hint: Notes show on hover; comments open sidebar for discussion [OK]

Common Mistakes:

• Thinking notes change cell values
• Believing comments are private
• Assuming notes only work on text cells

5. You want to suggest a change in a shared Google Sheet without altering the data. Which feature should you use and why?

hard

A. Add a comment to explain your suggestion, so others can reply and discuss

B. Insert a note with your suggestion, so it appears on hover

C. Directly edit the cell to show the new value

D. Use conditional formatting to highlight the suggested change

Solution

1. Step 1: Identify the best way to suggest changes without editing data

   Comments allow you to add suggestions and start discussions without changing the cell content.

2. Step 2: Compare with other options

   Notes are for quick reminders and less interactive. Editing changes data. Conditional formatting only changes appearance, not suggestions.

3. Final Answer:

   Add a comment to explain your suggestion, so others can reply and discuss -> Option A

4. Quick Check:

   Suggest changes = Use comments for discussion [OK]

Hint: Use comments to suggest without changing data [OK]

Common Mistakes:

• Editing cells directly instead of commenting
• Using notes which lack discussion features
• Relying on formatting to suggest changes