0
0
Google Sheetsspreadsheet

Comments and suggestions in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Concept Flow
   A          B  
1  Task     Status
2  Buy groceries Done
3  Clean house  In progress  <-- Comment here
4  Pay bills    Pending      <-- Suggestion here
This sheet shows a task list with two special cells: B3 has a comment, and B4 has a suggestion. These are indicated by small triangle markers in the cell corners.
Formula
Right-click cell B3 > Comment > Type 'Remember to vacuum before mopping.' Right-click cell B4 > Comment > Toggle to 'Suggested edit' > Type 'Consider paying bills online for convenience.'

User adds a comment to cell B3 and a suggestion to cell B4 using the Google Sheets interface.

Step-by-Step Trace
StepActionResult
1Add comment to B3Comment added: 'Remember to vacuum before mopping.'
2Add suggestion to B4Suggestion added: 'Consider paying bills online for convenience.'
3View sheetCells B3 and B4 show small triangle indicators for comment and suggestion
Comments and suggestions do not use formulas but are added via the UI and appear as indicators on cells.
Variable Tracker
CellContentType
B3In progressCell value with comment
B4PendingCell value with suggestion
Key Moments
Where does the comment indicator appear in the sheet?
What is the purpose of a suggestion in Google Sheets?
How do you add a comment to a cell?
Sheet Trace Quiz - 1 Questions
Test your understanding
What does the small triangle in the corner of a cell indicate?
AThe cell has a comment or suggestion
BThe cell contains a formula
CThe cell is empty
DThe cell is locked
Key Result
Comments and suggestions in Google Sheets are notes or proposals attached to cells. They appear as small triangle markers in the cell corner and help collaborators communicate without changing cell values.
Transcript
In this example, we have a task list. We add a comment to cell B3 by right-clicking and choosing 'Comment'. We type a reminder note. Then, we add a suggestion to cell B4 by right-clicking and choosing 'Comment', then toggling to 'Suggested edit', proposing an improvement. Both appear as small triangle indicators in the cells. These help collaborators see notes or suggestions without changing the actual data.