Fixing “Comments Disappearing” in Shared Google Sheets

You added detailed comments. Returned next day — comments gone. Or some comments still there, others missing. Random deletion seems to occur.

Before You Start: The 60-Second Diagnostic

Three checks:

• Check resolved comments: Resolved doesn’t mean visible by default.
• Verify cell still exists: Deleted cells lose their comments.
• Audit who can edit: Other editors may have deleted.

Step-by-Step Solution

H2: Show Resolved Comments

Comments may be resolved (hidden):

1. Click any cell.
2. Insert → Comment menu → All comments.
3. View shows all including resolved.

For showing resolved by default:
1. Comments icon in toolbar (speech bubble).
2. Settings → show resolved.

For team workflows: communicate when comments are resolved. Don’t surprise people with “disappeared” comments.

H2: Check Cell Deletion Impact

If cells were deleted:

1. Look at the row/column that previously had comments.
2. Was it deleted entirely?
3. Comments delete with their cells.

For recovery:
1. File → Version history → See version history.
2. Find version before cell deletion.
3. Restore or copy specific comments.

For permanent comment loss: comments don’t survive cell deletion.

For preservation:
– Don’t delete cells with important comments.
– Move data instead of deleting.

H2: Audit Comment Activity

function listAllComments() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheets = ss.getSheets();
  
  sheets.forEach(sheet => {
    // Sheet Notes (legacy)
    // and Threaded Comments
    // accessed differently
    const data = sheet.getDataRange().getNotes();
    data.forEach((row, r) => {
      row.forEach((note, c) => {
        if (note) {
          console.log(sheet.getName() + ' R' + (r+1) + 'C' + (c+1) + ': ' + note);
        }
      });
    });
  });
}

Lists all cell notes. For threaded comments: use Drive API for comprehensive enumeration.

H2: Use Comment Audit Trail

For team workbooks:

1. Document comment purposes.
2. Track who creates and resolves.

For Google Sheets:
– Activity dashboard: shows recent changes including comment additions/removals.
– Workspace admin tools: more detailed audit.

For workflows where comments are critical:
– Train team on comment etiquette.
– Establish “don’t delete others’ comments” rule.

H2: Convert to Cell Content

For permanent annotation:

1. Move important comment content to cells.
2. Use a “Notes” column adjacent to data.

Comments are auxiliary; notes column is part of the data. Survives all operations.

For mission-critical annotations: notes column is more reliable than comments.

For ephemeral discussions: comments are fine. Just understand they may not persist forever.

H2: Restore from Version History

If comments are gone:

1. File → Version history → See version history.
2. Find a version with comments intact.
3. Either:
4. – Restore to that version (loses recent edits).
5. – Or note the comment content, manually re-create.

For mass restoration: not practical via UI. Apps Script could extract from versioned snapshots.

For mission-critical comments: backup via export periodically.

Information Gain Box: The Hidden Comment Migration

Here is what affects long-lived sheets: Google migrated from Notes to Threaded Comments around 2020, and old Notes may behave differently than new Comments.

Legacy Notes:
– Created via right-click → Insert note.
– Per-cell yellow callout.
– Cannot be replied to.

Threaded Comments:
– Created via right-click → Comment.
– Thread of replies.
– Can be assigned to users.
– @mentions notify users.

For mixed sheets: both types may exist. Different management.

For viewing:
– Notes: hover over cell.
– Comments: comment icon on cell.

For preservation: same caveats. Both can be lost via cell deletion.

This Notes vs Comments distinction is documented in Sheets help but rarely surfaces until both types are mixed. Many “comment gone” issues trace to confusion between types.

Comparison Table: Wrong Way vs. Correct Way

Issue	Wrong Way	Correct Way
Disappeared comments	Panic	Check resolved + version history
Deleted cells	Hope comments survived	Recreate or use version history
Audit	Trust UI	Apps Script to enumerate
Critical info	Comments only	Notes column in data
Resolve workflow	Hide resolutions	Communicate when resolving
Mass changes	Lose context	Document comments separately
Cross-platform	Notes vs Comments mixed	Standardize on one type

Original Image Descriptions

Screenshot 1: Show Google Sheets with several cells previously having comments — now bare. User confused. Comments menu shows resolved comments hidden by default. Draw a red circle around the cells without indicators. Add a red annotation: “Comments may be resolved or cells may have been deleted — check Version history.”

Screenshot 2: Show Activity dashboard showing comment additions/resolutions/deletions over time. User can see what happened to specific comments. Draw a red circle around the activity timeline. Add a red annotation: “Activity audit reveals comment history.”

Frequently Asked Questions

Q: Will exporting the sheet preserve comments?
A: Partially:
– Export to Excel: comments preserved (as cell notes).
– Export to PDF: comments preserved as annotations.
– Export to CSV: comments lost.

For mission-critical: PDF or Excel export retains.

Q: Can I prevent comment deletion?
A: For shared sheets, all editors can delete any comment. For protection: convert critical comments to cell content (notes column).

Q: Does Excel have similar comment issues?
A: Excel comments behave similarly:
– Modern (Threaded): like Google’s.
– Legacy (Notes): yellow callouts.

Both can be deleted by any editor with appropriate permissions. Same protection considerations.