It’s 3:12 PM. You just pasted Q2 sales data from Finance into your presentation-ready dashboard. The cells came with thick blue borders around every single one — even inside merged headers and blank rows. Your VP walks by in 8 minutes. You click the Border button. Nothing changes. You try again. Still there. You’re about to Ctrl+Z five times and start over.
Quick Answer
To remove borders in Excel, select the cells, then press Alt + H + B + N (Home → Borders → No Border). That’s it — no menus, no right-clicking, no hunting for tiny icons. If borders persist, they’re likely applied via conditional formatting or table styles — not standard cell borders — and need different handling.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Keyboard Shortcut | Select cells → Alt + H + B + N | Speedy removal across any selection | Fails if borders are from Table Styles or Conditional Formatting |
| Home Tab → No Border | Select cells → Home tab → Borders dropdown → No Border | Beginners; visual confirmation | Easy to miss when zoomed out; requires mouse precision |
| Format Cells Dialog | Right-click → Format Cells → Border tab → Click None → OK | Precise control; confirms border source | Slowest method; buried under two layers of UI |
| Clear All Formatting | Select cells → Home → Clear → Clear Formats | When fonts, fills, and borders all need resetting | Wipes fonts, alignment, number formats — not just borders |
| Table Style Override | Click inside table → Table Design → Uncheck Banded Rows / First Column; then use Alt+H+B+N | Excel Tables where borders reappear after sorting | Doesn’t affect non-table ranges; requires table awareness |
Method 1 Deep Dive: The Keyboard Shortcut (Alt + H + B + N)
This is the fastest way — and the one most people never learn because Excel hides it behind four keystrokes. Let’s walk through it using real data.
You’ve got this small dataset in A1:D7:
| Region | Sales Rep | Q2 Revenue | Close Date |
|---|---|---|---|
| North | Sarah Chen | $45,200 | 2024-03-15 |
| South | James Okafor | $38,950 | 2024-03-22 |
| West | Lena Park | $52,100 | 2024-04-01 |
| East | Diego Ruiz | $41,600 | 2024-04-05 |
| Central | Amina Diallo | $47,800 | 2024-04-10 |
Every cell has a thin black border — maybe from copying from another sheet, or a previous template. You want clean, minimal formatting.
Do this: Click and drag to select A1:D7. Hold Alt, then press HBN (selects No Border). Done. Borders vanish instantly.
Here’s the counterintuitive part: If you press Alt + H + B and *stop*, you’ll see the Borders gallery pop up with options like “All Borders”, “Outside Borders”, etc. But pressing N while that gallery is open *doesn’t* choose “No Border” — it selects the top-left icon (which is usually “No Border”). So yes, N works — but only because Excel maps it to position 1 in the gallery. Not intuitive, but reliable.
What if nothing happens? Check if your selection includes merged cells. Merged cells sometimes retain border metadata even after clearing. In that case, unmerge first (Alt + H + M + U), clear borders, then re-merge if needed.
Method 2 Deep Dive: When Borders Won’t Go Away (The Hidden Culprits)
Let’s say you tried Alt + H + B + N on F2:F10, and the borders are still there. That’s not user error — it’s Excel being quietly stubborn.
Open the sample range below (in F1:G10):
| Product | Status |
|---|---|
| CloudSync Pro | Live |
| DataShield Lite | Beta |
| FlowLink Enterprise | Live |
| VaultGuard Basic | Deprecated |
| InsightPulse Standard | Beta |
These borders aren’t from manual formatting. They’re from a conditional formatting rule that adds a bottom border to every row where Status = "Beta". You can tell because selecting just one cell shows no border in the Home tab — yet the border appears on screen.
To fix it: Select F2:G10 → Home tab → Conditional Formatting → Manage Rules → Find the rule applying borders → Delete it. Or, faster: Select the range → Home → Conditional Formatting → Clear Rules → Clear Rules from Selected Cells.
Another sneaky source: Excel Tables. If your data lives inside a table (created with Ctrl + T), borders come from the Table Style — not individual cell formatting. Try removing borders manually, then sort or filter. Poof — they’re back. That’s the table style enforcing them.
The fix? Click any cell inside the table → go to the Table Design tab → in the Table Style Options group, uncheck Banded Rows, First Column, and Last Column. Then apply Alt + H + B + N to the entire table body (not the header row — that’s styled separately).
Pro tip: If you frequently paste from web pages or emails, those often bring embedded HTML borders. Use Paste Special → Values (Alt + E + S + V) first — then format. Saves hours.
Cheat Sheet
| Action | Shortcut / Steps | Notes |
|---|---|---|
| Remove standard borders | Alt + H + B + N | Works on any selection — cells, rows, columns |
| Clear *all* formatting | Alt + H + E + F | Removes fonts, fills, alignment — not just borders |
| Unmerge & clear | Alt + H + M + U, then Alt + H + B + N | Merged cells often hold onto border state |
| Clear conditional formatting | Home → Conditional Formatting → Clear Rules → From Selected Cells | Use when borders reappear after editing |
| Disable table borders | Table Design → uncheck Banded Rows, First Column, Last Column | Required before Alt+H+B+N works reliably in tables |
| Paste without borders | Alt + E + S + V (Values only) | Prevents imported HTML borders from sticking |
