The first thing most people do when trying to remove borders in Excel is select the cells, go to the Home tab, click the Borders dropdown, and choose No Border. That often doesn’t work — especially if borders were applied via Conditional Formatting, Table Styles, or merged cells. You’ll still see faint lines, ghost outlines around empty rows, or stubborn borders reappearing after paste operations. It’s not your fault — Excel treats borders as layered formatting, and ‘No Border’ only clears manually applied ones.
Quick Answer
To fully remove borders in Excel: select the range (e.g., A1:D10), press Alt + H + B + N to clear all manual borders, then check Format Cells > Border tab to confirm no line style is selected — and finally, right-click → Clear Formats if borders persist from Table Styles or Conditional Formatting.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Home Tab → No Border | Select cells → Home → Borders dropdown → No Border | Quick removal of basic manual borders | Ignores borders from Tables, Conditional Formatting, and cell styles |
| Clear Formats | Select cells → Home → Clear → Clear Formats (or Ctrl + Shift + Space) | Removing *all* formatting — borders, fonts, fills, alignment | Destroys font size, colors, number formats — use only if you don’t need other formatting |
| Format Cells Dialog | Right-click → Format Cells → Border tab → Select “None” → OK | Precise control; confirms no border line is active | Doesn’t affect borders from Table Styles or conditional rules |
| Table Style Override | Click inside table → Table Design → uncheck “Banded Rows”, “First Column”, etc. → set Table Style to “None” | Removing gridlines from structured Excel Tables | Only works on actual Tables (Ctrl + T), not regular ranges |
| Conditional Formatting Audit | Home → Conditional Formatting → Manage Rules → delete any rule applying borders | Eliminating invisible, rule-driven borders | Easy to overlook — many users never check this |
| Page Layout View Toggle | Go to Page Layout tab → uncheck “View Gridlines” (affects screen only, not print) | Hiding non-printing gridlines that look like borders | Not real borders — just display settings. Doesn’t change cell formatting. |
Method 1 Deep Dive
Let’s say you’ve got a sales summary in A1:E8 with light gray borders around each cell — maybe copied from a report or pasted from a website. Sarah Chen entered data for Acme Corp, and now the borders clash with her clean dashboard design.
You try Alt + H + B + N — the fastest keyboard shortcut to apply ‘No Border’. But row 5 still shows a thick bottom border under “Q2 Revenue”. Why? Because that row was formatted as part of an Excel Table (created with Ctrl + T), and Table Styles override manual border commands.
Here’s what actually works: First, click any cell inside the table (say, C3). Go to the Table Design tab. In the Table Style Options group, uncheck Banded Rows and First Column. Then, in the Table Styles gallery, scroll all the way to the left and pick None. Now the borders vanish — even the ones that resisted Alt+H+B+N.
Sample before/after:
| Region | Q1 Sales | Q2 Sales | Rep |
|---|---|---|---|
| North | $42,100 | $45,200 | Sarah Chen |
| South | $38,900 | $41,300 | James Wu |
| West | $51,700 | $53,800 | Lena Patel |
After applying Table Style → None, all borders disappear — no extra steps, no format loss, and no risk of breaking the table structure.
Method 2 Deep Dive
Now imagine you’re reviewing a budget file from Finance — columns A:C contain vendor names, invoice dates (like 2024-03-15), and amounts ($1,240.50). Someone used Conditional Formatting to highlight overdue invoices with red borders — but those borders don’t show up in the Borders dropdown menu. So clicking ‘No Border’ does nothing.
Here’s the counterintuitive fix: Go to Home → Conditional Formatting → Manage Rules. In the dialog, look for any rule with “Border” in the description or preview. You’ll likely find one titled “Overdue Invoices – Red Border”. Select it and click Delete Rule.
Surprising tip: Even if you *don’t* see a visible border on-screen, Conditional Formatting can apply borders to cells that meet criteria — like blank cells, negative values, or dates older than today. Always audit this list if borders won’t budge.
Try it on this range: B2:B10 contains dates. If B5 = 2023-11-02 and today is 2024-04-10, that cell may have an invisible red border applied by a rule like “Format only cells that contain: Date occurring before: =TODAY()-30”. Delete that rule — and the border vanishes instantly.
Cheat Sheet
| Action | Keyboard Shortcut | When to Use It |
|---|---|---|
| Clear manual borders only | Alt + H + B + N | You know borders were added manually — no tables or rules involved |
| Clear *all* formatting | Ctrl + Shift + Space | You’re rebuilding formatting from scratch — fast, nuclear option |
| Remove Table borders | None (UI only) | Your data lives in a Ctrl+T table — go to Table Design → Table Style → None |
| Audit Conditional Formatting | Alt + H + L + M | Borders appear/disappear based on content — always check here first |
| Confirm zero borders in Format Cells | Ctrl + 1 → Border tab → click “None” → OK | Final verification step — especially after pasting from external sources |
