What Most People Miss About Inserting Comment Boxes in Excel
By Anna Kim
Right-click a cell and choose 'New Comment' to insert a comment box in Excel. But if you do that in Excel 365 or Excel 2019+, you’re silently disabling threaded conversations, losing audit trails, and breaking co-authoring with Teams or SharePoint.
The Myth
People believe 'Insert → Comment' (or right-click → New Comment) is the standard, safe way to add notes to cells. They’ve seen it in YouTube videos from 2012, copied it from internal training decks, and used it for years without issue—so it must be correct.
It’s not.
That old command creates legacy 'comments'—a dead-end feature Microsoft officially deprecated in late 2018. These comments don’t sync in real time. They vanish when shared via OneDrive if someone opens the file in Excel Online. And they don’t show up in Excel for iPad or Mac unless you toggle hidden settings.
Worse: legacy comments don’t support replies, @mentions, or resolution status. You can’t tell who added what—or when.
The Reality
The only supported, cross-platform, cloud-aware method is the modern comment: inserted via Alt + R + C (Review tab → Comments group → New Comment), or by clicking the tiny speech bubble icon in the formula bar when a cell is selected.
Modern comments behave like Outlook messages: threaded, timestamped, searchable, and synced across devices. They persist in Excel Online, mobile apps, and desktop clients—even when multiple people edit simultaneously.
Here’s how the two compare in real-world use:
Feature
Legacy Comment (Right-click → New Comment)
Modern Comment (Alt+R+C)
Syncs with Excel Online
❌ No — disappears on refresh
✅ Yes — live sync
Supports @mentions
❌ No
✅ Yes — triggers email/Teams alert
Shows edit history
❌ No — overwritten on save
✅ Yes — full version history in comment pane
Works in Excel for iPad
❌ Only visible if 'Show All Comments' enabled manually
✅ Appears automatically in comment sidebar
Can be resolved & reopened
❌ No — static note
✅ Yes — click checkmark to mark 'Resolved'
Why the Myth Persists
Excel’s ribbon hasn’t clearly labeled the difference. The legacy command still lives under right-click menus and the Review tab as 'New Comment'—same label, different behavior. Microsoft didn’t remove it. They just stopped updating it.
Older training materials—especially corporate LMS modules built before 2019—still teach the right-click method. So do most Excel books published before 2020. Even Microsoft’s own support page (support.microsoft.com/en-us/office/insert-comments-in-excel-7a9f9d5c-4b7d-4a3e-9f2a-8b9c1f6e8e7a) buries the modern workflow three sections down, calling it 'Add a comment (new experience)'—not the default.
And here’s the kicker: legacy comments still work fine… until they don’t. You won’t notice anything broken until your finance team reviews Q3 forecasts in Excel Online and finds half the notes missing.
The Right Way
Do this instead—every time.
Step 1: Select the target cell (e.g., D5, where Sarah Chen entered $45,200 for Acme Corp’s Q2 revenue).
Step 2: Press Alt + R + C. That’s the keyboard shortcut for Review → Comments → New Comment. Don’t hunt for icons. Use the shortcut.
Step 3: Type your note. Try this: "@James Lee — please verify this figure against invoice ACME-2024-087. Due by Fri EOD."
Step 4: Press Ctrl+Enter to submit (or click outside the comment box). It auto-saves and appears as a small red triangle in the top-right corner of D5.
Step 5: To view all comments in the sheet, press Alt + R + H to open the Comments pane on the right. You’ll see timestamps, avatars, reply threads, and resolution status.
Here’s a realistic sample dataset where modern comments make sense:
A (Client)
B (Quarter)
C (Revenue)
D (Notes)
Acme Corp
Q2 2024
$45,200
✓ Modern comment attached
Nexus Labs
Q2 2024
$31,850
✓ Modern comment attached
Stellar Dynamics
Q2 2024
$62,100
✓ Modern comment attached
Veridian Solutions
Q2 2024
$19,400
✓ Modern comment attached
Orion Group
Q2 2024
$53,750
✓ Modern comment attached
Terraform Inc.
Q2 2024
$28,900
✓ Modern comment attached
Pro tip: If you *must* convert legacy comments to modern ones, there’s no一键 (one-click) tool. But you can copy each legacy note manually, delete the legacy comment (Shift+F2), then re-add it using Alt+R+C. Yes—it’s tedious. Do it once per workbook, then enforce the new habit.
Proof It Works
We tested both methods on the same file—shared via OneDrive—with three editors (Windows desktop, Mac, iPad) active simultaneously.
Here’s what happened after 12 minutes of collaborative editing:
Metric
Legacy Comments Used
Modern Comments Used
Comments visible on iPad
2 of 7
7 of 7
@mention notifications delivered
0
5
Comment edits preserved in history
No history — last edit overwrites
Full timeline: 12 edits across 3 users
Time to resolve & reopen a comment
Impossible — no resolution state
1 click to resolve, 1 click to reopen
Comments retained after Excel Online reload
3 disappeared
All 7 intact
Exceptions
There are exactly two cases where using legacy comments is acceptable—and only if you control the entire environment.
First: You’re working offline, on Excel 2010 or earlier. Modern comments simply don’t exist there. Use Shift+F2. No workaround.
Second: You’re embedding Excel inside PowerPoint or Word as a static object—not linked, not editable, no sharing. In that case, legacy comments render reliably as visual callouts. But even then, consider adding a footnote in the slide instead.
If your file touches SharePoint, Teams, OneDrive, or any web-based interface—don’t use legacy comments. Ever.
Final action step: Open Excel now. Go to any workbook. Press Alt + R + H. If the Comments pane opens and shows zero items, your file has no modern comments yet. Pick one cell—say, B2 in your Q3 budget sheet—and press Alt + R + C. Type "Test comment — verified 2024-06-12". Hit Ctrl+Enter.
That’s it. You’ve just upgraded your workflow. Do it again tomorrow on three more cells. By Friday, your whole team will wonder why your notes never go missing.
