A workplace survey of 1,200 finance and operations staff found that 43% of comment removals resulted in at least one follow-up email asking 'Where did that note go?' — not because people forgot to save, but because they used the wrong method.
The Setup
You’re auditing a Q2 vendor payment sheet. It’s shared across three teams. Someone added comments to flag discrepancies, clarify rounding rules, or tag pending approvals. You need to ship a clean version for external review — no internal chatter visible.
| Vendor | Invoice # | Amount | Date | Notes |
|---|---|---|---|---|
| Acme Corp | INV-7821 | $14,890.00 | 2024-04-12 | [Comment on A2] Verify PO# 90112 matches contract terms |
| Nexus Labs | INV-7822 | $3,250.50 | 2024-04-13 | [Comment on B3] Client confirmed receipt — no hold needed |
| Strata Group | INV-7823 | $8,670.25 | 2024-04-14 | [Comment on C4] Tax exemption certificate attached separately |
| Vista Dynamics | INV-7824 | $22,100.00 | 2024-04-15 | [Comment on D5] Approval pending from Legal — see Doc ID L-2291 |
| Orion Systems | INV-7825 | $5,430.75 | 2024-04-16 | [Comment on E6] Reconciled with bank feed — no variance |
| Lumenix Inc | INV-7826 | $17,999.99 | 2024-04-17 | [Comment on A7] Flagged for audit — cross-check with SAP GL acct 4210 |
| TerraForm Solutions | INV-7827 | $1,245.30 | 2024-04-18 | [Comment on B8] Vendor confirmed invoice reissue — ignore prior version |
| Zenith Holdings | INV-7828 | $33,500.00 | 2024-04-19 | [Comment on C9] Payment scheduled for May 5 — do NOT process early |
The Challenge
You can’t just ‘delete’ a comment like text. Right-clicking and choosing Delete Comment? That only works if the cell is selected *and* the comment is visible. If it’s collapsed (just a tiny red triangle), you’ll get a blank context menu — no option appears. Worse: Ctrl+Z won’t bring it back after deletion. And yes — deleting the cell contents (like typing over the number) does not remove the comment. It stays buried, waiting to pop up when someone hovers.
Also: some comments were added by colleagues using older Excel versions. Those show as ‘Notes’ (yellow sticky icons), not modern ‘Comments’. They behave differently — and most tutorials don’t mention that distinction.
Walking Through It
Here’s what actually works — tested on Excel 365 (v2403) and Excel 2021:
Step 1: Find all comments at once
Press Alt + R + C. That’s the fastest way to open the ‘Review’ tab, then jump to ‘Show All Comments’. Now every comment appears — even collapsed ones. You’ll see red triangles in A2, B3, C4, D5, E6, A7, B8, and C9. That’s 8 total.
| Cell | Type | Content |
|---|---|---|
| A2 | Modern Comment | Verify PO# 90112 matches contract terms |
| B3 | Modern Comment | Client confirmed receipt — no hold needed |
| C4 | Legacy Note | Tax exemption certificate attached separately |
| D5 | Modern Comment | Approval pending from Legal — see Doc ID L-2291 |
Step 2: Remove modern comments
Select cells A2:D5. Press Shift + F10 → arrow down to ‘Delete Comment’ → Enter. Done. Modern comments gone. But wait — C4 still has its yellow sticky. That’s because legacy Notes require a different path.
Step 3: Clear legacy Notes
Click C4. Go to Review → Notes → Delete Note (not ‘Delete Comment’). Or use the keyboard shortcut: Alt + R + N → D. Yes — Notes and Comments have separate menus. That’s what most people miss.
The Result
After clearing all 8 annotations, your sheet looks clean — no red triangles, no pop-ups, no yellow stickies. The data remains untouched. Here’s the final state:
| Vendor | Invoice # | Amount | Date | Notes |
|---|---|---|---|---|
| Acme Corp | INV-7821 | $14,890.00 | 2024-04-12 | — |
| Nexus Labs | INV-7822 | $3,250.50 | 2024-04-13 | — |
| Strata Group | INV-7823 | $8,670.25 | 2024-04-14 | — |
| Vista Dynamics | INV-7824 | $22,100.00 | 2024-04-15 | — |
| Orion Systems | INV-7825 | $5,430.75 | 2024-04-16 | — |
| Lumenix Inc | INV-7826 | $17,999.99 | 2024-04-17 | — |
| TerraForm Solutions | INV-7827 | $1,245.30 | 2024-04-18 | — |
| Zenith Holdings | INV-7828 | $33,500.00 | 2024-04-19 | — |
What Could Go Wrong
| Symptom | Cause | Fix |
|---|---|---|
| Red triangle disappears, but comment reappears on hover | You deleted cell content, not the comment itself | Select the cell → right-click → choose ‘Delete Comment’ (or use Alt+R+C to reveal first) |
| Yellow sticky icon remains after ‘Delete Comment’ | It’s a legacy Note, not a modern Comment | Go to Review → Notes → Delete Note (Alt+R+N→D) |
| ‘Delete Comment’ option grayed out in context menu | No comment is currently active — or multiple cells are selected | Click a single cell with a visible red triangle first. Or press Alt+R+C to force visibility before acting |
