You converted a range into a table, used those colorful banded rows for a while—and now you want it gone. Maybe the striped styling clashes with your report. Maybe a copy-paste from another workbook dragged unwanted formatting into your sheet. Whatever the reason, how to remove table formatting in Excel turns out to be one of those small skills that saves you ten minutes every time you need it.
Here's the catch: there's no single button labeled "remove table formatting." Excel actually has at least three different operations bundled under that phrase, and the right one depends on what you actually want gone. Do you want the colors gone but the table structure kept? The whole table converted back to a plain range? Or every shred of formatting—fonts, borders, fills—wiped clean? Each path is short, but you've got to pick the correct one or you'll get a frustrating surprise.
This guide walks you through each method with exact ribbon clicks and keyboard shortcuts. You'll see the difference between Clear, None, and Convert to Range—three options that look almost identical in the menus but produce very different results. We'll also cover the stubborn cases: tables that won't lose their banded rows, formatting that comes back after you save, and the dreaded "table style" that survives every clear command.
If you're brushing up on spreadsheet skills for a job test, an interview task, or just trying to clean up an inherited workbook, this is exactly the kind of question that comes up. Want broader Excel practice? Try our Excel practice test after you finish here—it covers tables, formulas, and formatting in one go. Bookmark this page too; you'll likely come back to it the next time someone hands you a workbook drowning in mismatched styles.
Below are the five working approaches. Pick the one that matches your goal. They all take under a minute—some take under five seconds once you get the keyboard chain memorized.
This wipes the banded rows, header color, and any preset style—but leaves the table as a table. You still get filters, structured references, and the auto-expand behavior. Use this when you like tables but hate the default blue.
Boom—the colors vanish but the table is still a table. You'll know because the Filter dropdowns on each header stay put. Add a new row directly below and Excel still auto-extends the table to include it.
This is the nuclear option for table behavior. The cells become a plain range again, filters disappear, and structured references like =Table1[Sales] get replaced with cell addresses like =B2:B50. The visual formatting stays unless you clear it separately.
The keyboard speedster's version: Alt + J, T, G when you're on the Table Design tab. After the conversion, the cells still look like a table—that's because the formatting is separate from the table object. To strip the colors too, run method 3.
Use this when you want everything gone—fills, fonts, borders, number formats, the whole lot. The data stays; only the look-and-feel disappears.
The shortcut chain is Alt + H, E, F. This won't touch your formulas or values—only the visual layer. Number formats (like currency or percentage) get reset to General, so revisit those after if you need them back.
Sometimes the "table formatting" you're seeing isn't from the table style at all—it's conditional formatting rules layered on top. Method 3 won't clear those. Here's the fix:
You can spot conditional formatting because the colors often respond to cell values—type a different number and the color changes. That's your tell. Data bars, icon sets, and color scales are all forms of conditional formatting too, so they'll vanish here as well.
Sometimes you just want it gone. Select the whole table by clicking the small triangle in the top-left of the first column header, then press Delete to clear contents, or right-click and choose Delete > Table Rows to remove it row by row. If you only want to drop the structure without losing data, jump to method 2 instead.
A few things trip people up consistently. Here's what to watch for if your first attempt doesn't deliver the clean sheet you expected.
When you pick None from the styles gallery, Excel removes the named style but keeps any direct cell formatting you applied—like manually setting a fill color on row 5. If colors persist after picking None, that's manual formatting, and you'll need method 3 (Clear Formats) to nuke it. Direct formatting always wins over style-based formatting in Excel's render order, which is why this catches so many people out.
If only the alternating row colors are bothering you, you don't need to remove the whole style. On the Table Design tab, uncheck Banded Rows in the Table Style Options group. Same for Banded Columns, Header Row, and Total Row. These toggles affect display only and don't touch your data. You can flip them back on later without losing anything.
Occasionally formatting reappears after closing and reopening the file. Usually that's because the table is referenced by a pivot table, a chart, or a defined name that's redrawing it. Check for those connections via Formulas > Name Manager before assuming Excel is broken. Also watch out for VBA macros that auto-apply styling on workbook open; those run quietly behind the scenes and undo your cleanup.
If you paste data from a styled table into your "clean" sheet, you can drag in the formatting along with the values. Use Paste Special > Values (Ctrl + Alt + V, then V) to bring in only the numbers without any visual baggage. For one-off pastes, the small clipboard icon that appears post-paste lets you switch to "Values only" without re-doing the action.
Before you strip everything, consider this: Excel tables are genuinely useful. They auto-expand when you add rows. They give you structured references that survive sorting. They handle banded rows for readability. For most working spreadsheets, the formatting helps more than it hurts.
The right move is often to keep the table structure but apply a subtler style. Pick a lighter color from the gallery, or build a custom style with no fill and just a thin bottom border on the header. That gets you all the table behavior without the loud visuals. The Excel formulas reference and the Excel spreadsheet guide both walk through table best practices if you want to dig deeper into when tables pay off versus when a plain range is the better choice.
Once you've practiced these steps a few times, removing table formatting becomes a reflex—two clicks or four keystrokes, depending on how you like to work. That's exactly the kind of micro-skill that adds up over a career of spreadsheet work. Ready to test what you know? The Excel practice tests on this site cover formatting, formulas, pivot tables, and the kind of "real workbook" cleanup scenarios you'll face in any office job.