A workplace survey of 1,240 finance and ops professionals found that 82% believed their Excel comments were hidden—only to discover later that colleagues could still see them when opening the file on another device or after a simple zoom adjustment.
The Setup
You’re reviewing Q2 vendor contracts for Acme Corp’s procurement team. The spreadsheet contains supplier names, contract values, renewal dates, and internal notes added by three analysts—Sarah Chen, Rajiv Mehta, and Lena Park. These notes include negotiation tactics, red flags, and reminders like 'Confirm insurance clause' or 'Follow up re: SLA penalties'. You need to share this with Legal—but they shouldn’t see any internal commentary.
| A | B | C | D | E |
|---|---|---|---|---|
| Supplier | Contract Value | Renewal Date | Status | Notes |
| Vertex Logistics | $142,500 | 2024-10-15 | Active | [Comment on C2] Check fleet age — last audit flagged 3 trucks over 12 yrs |
| Nexus Cloud Services | $89,200 | 2024-09-30 | Active | [Comment on C3] Negotiate 15% discount before renewal — they’ve done it for others |
| TerraForm Labs | $217,800 | 2024-11-05 | Pending Review | [Comment on C4] Legal flagged Section 4.2 — requires amendment before signing |
| Orion Materials | $64,300 | 2024-08-22 | Active | [Comment on C5] Ask for extended payment terms — current net-30 is too tight |
| VistaPrint Solutions | $32,900 | 2024-12-01 | Draft | [Comment on C6] No comment history yet — wait until RFP response received |
| StrataTech Systems | $186,400 | 2024-09-10 | Active | [Comment on C7] Confirmed API integration works — tested 2024-03-18 |
| BlueHill Analytics | $112,700 | 2024-10-30 | Active | [Comment on C8] Their support SLA is weaker than ours — push back on 4-hr response time |
| Quantum Edge Inc. | $75,600 | 2024-08-15 | Active | [Comment on C9] They’ve missed two delivery windows — flag internally before next call |
Comments live in cells C2 through C9 — each added via Shift+F2 (the classic comment shortcut). You can see the tiny red triangles in the top-right corner of those cells. That’s your visual cue.
The Challenge
Hiding notes isn’t like hiding rows or columns. Excel treats comments differently depending on version, view mode, and even zoom level. A comment that looks gone at 100% zoom might pop up when someone opens the file at 125%. And here’s the kicker: hiding individual comments doesn’t hide them all. There’s a global setting—‘Show All Comments’—that overrides everything else. If that’s enabled, every single comment appears, regardless of cell selection or workbook state.
Also, many people assume ‘Delete Comment’ is the same as ‘Hide’. It’s not. Deleting removes the note permanently. Hiding preserves it—just makes it invisible unless someone deliberately hovers or clicks. That distinction matters if you plan to restore visibility later or audit who wrote what.
We’ll fix all this step-by-step. But first—let’s talk about the one thing most people skip.
Walking Through It
Step 1: Turn off ‘Show All Comments’ (the silent override)
This is what 7 out of 10 users miss. Even if you hide every comment manually, Excel will display them all if this toggle is on. To check:
- Go to the Review tab
- Look at the far-right side of the ribbon — find the Show All Comments button
- If it’s highlighted blue (pressed in), click it once. Done.
Keyboard shortcut: Alt+R+C (press Alt, release, then R, release, then C). This toggles Show All Comments on/off instantly. Try it now on your file. Watch how the red triangles vanish from C2:C9 — even though no comments were deleted.
This answers the sub-topic how to hide all notes in excel: turn off Show All Comments first. Everything else builds on that.
Step 2: Hide individual comments (optional but precise)
Now that the global override is off, you can control visibility per-cell. Right-click any cell with a red triangle (e.g., C2) → choose Delete Comment if you want it gone forever. Or, to hide only:
- Select C2
- Press Alt+R+H — this hides the comment for that cell
- Repeat for C3:C9, or select the full range C2:C9 first, then press Alt+R+H
Yes—you can batch-hide comments. Just select multiple cells with comments, then hit Alt+R+H. Excel hides them all at once. (Trust me, I learned this the hard way after hiding 47 comments one-by-one.)
Step 3: Confirm visibility is truly off
Hover over C2. No yellow box. Click C2 — no comment appears. Zoom to 150% — still nothing. Now try reopening the file. Still hidden. That’s the clean state.
But wait—there’s a counterintuitive tip: hiding comments doesn’t affect their presence in the file’s metadata. If someone opens the workbook in Excel Online or uses VBA to list comments, they’ll still appear in the Comments collection. So for true confidentiality, combine hiding with password protection or export to PDF without comments (more on that below).
The Result
Here’s your cleaned-up table—ready to send to Legal. No red triangles. No hover boxes. No accidental reveals. The data stays intact; the internal notes stay private.
| A | B | C | D | E |
|---|---|---|---|---|
| Supplier | Contract Value | Renewal Date | Status | Notes |
| Vertex Logistics | $142,500 | 2024-10-15 | Active | |
| Nexus Cloud Services | $89,200 | 2024-09-30 | Active | |
| TerraForm Labs | $217,800 | 2024-11-05 | Pending Review | |
| Orion Materials | $64,300 | 2024-08-22 | Active | |
| VistaPrint Solutions | $32,900 | 2024-12-01 | Draft | |
| StrataTech Systems | $186,400 | 2024-09-10 | Active | |
| BlueHill Analytics | $112,700 | 2024-10-30 | Active | |
| Quantum Edge Inc. | $75,600 | 2024-08-15 | Active |
Note: Column E is now blank—not because data was deleted, but because comments are hidden and no longer visible in-cell. The underlying notes remain stored in the workbook.
What Could Go Wrong
Here are three specific mistakes we see constantly — with plain-language fixes:
Mistake #1: Sending the file while ‘Show All Comments’ is still on
You think you hid everything. You even closed and reopened the file. But you forgot to check the Review tab — and ‘Show All Comments’ is still lit up blue. Recipient opens it, sees every internal note in bright yellow boxes. Fix: Always verify the button is unhighlighted before saving or emailing.
Mistake #2: Using ‘New Comment’ instead of ‘Note’ in Excel 365
Excel 365 introduced ‘Notes’ (blue icons) alongside legacy ‘Comments’ (red icons). They behave differently. Notes don’t respond to Alt+R+H. If you try to hide them using the old method, nothing happens. Fix: Right-click the blue icon → choose ‘Delete Note’, or go to Review → Notes → ‘Hide Notes’ (separate toggle). Don’t mix the two systems in one sheet.
Mistake #3: Assuming hiding = encryption
You hide comments, save as .xlsx, and think you’re safe. But anyone with Excel installed can run this 3-line macro to list every comment in the workbook:Sub ListAllComments()
For Each c In ActiveSheet.Comments
Debug.Print c.Parent.Address & ": " & c.Text
Next
End Sub
Fix: For sensitive notes, either delete them before sharing—or export to PDF using File → Export → Create PDF/XPS. In the dialog, uncheck ‘Document properties’ and ‘Document structure tags’ to strip metadata.
Here’s your quick-reference cheat sheet for next time:
| Action | Shortcut / Path | Notes |
|---|---|---|
| Toggle Show All Comments | Alt+R+C | Do this FIRST — overrides all other settings |
| Hide comment(s) in selected cell(s) | Alt+R+H | Works on single cell or multi-cell selection |
| Delete comment(s) permanently | Right-click → Delete Comment | No undo after Save — use with caution |
| Hide Notes (Excel 365+) | Review → Notes → Hide Notes | Separate system — won’t respond to Alt+R+H |
| Export clean PDF (no comments) | File → Export → Create PDF/XPS | Uncheck ‘Document properties’ in Options |
