Excel table formatting can stay visible because the cells are still part of an Excel table. You can clear the table style and keep sorting, filtering, and table behavior, or convert the table back to a normal range. Start with the option that removes the least, then clear cell formats only when the old look remains.
Remove the table style but keep the table
The most common cause is that the table still has a style applied from Excel's Table Styles gallery.
Select any cell inside the table.
Open Table Design, then open the Table Styles gallery.
Choose More, then select Clear.
Excel keeps the data as a table and shows it in the default table format.
You can also go to Home, choose Format as Table, open the same gallery, and select Clear.
Turn off banded rows, headers, and filter buttons
Use this when the table structure is useful, but one visual option is too much. Select any cell in the table, then open Table Design.
On a Mac, use the Table tab instead. In Excel for the web, use Table Design and Table Style Options.
In Table Style Options, turn off any option you do not want: Header Row, Total Row, First Column, Last Column, Banded Rows, Banded Columns, or Filter Button.
Convert the table to a normal range
This fixes a table that should behave like ordinary worksheet cells.
Click anywhere inside the table.
Go to Table Design.
In Tools, choose Convert to Range.
On a Mac, click anywhere in the table.
Open the Table tab.
Choose Convert to Range.
Select Yes.
After conversion, the data is no longer an Excel table, and the existing formatting remains until you clear it.
Clear the leftover formatting after conversion
Select the converted cells, rows, or columns that still have the old table look.
Go to Home.
Choose Clear.
Select Clear Formats.
If the style keeps reappearing, use Table Design and Convert to Range first, then run Home, Clear, Clear Formats on the converted range.
Select only the area you want to clean so formatting elsewhere in the sheet stays unchanged.
Use the right-click shortcut
This is the context-menu route for removing table behavior. Right-click inside the table, choose Table, then select Convert to Range.
The table becomes a normal range, and the visible formatting remains. To remove that look too, select the converted cells and use Home, Clear, Clear Formats.
Use the ribbon method or the right-click method; both convert the Excel table to a range.
Delete the table and its formatting
Select all cells in the table.
Go to Home.
Choose Clear.
Select Clear All.
This removes the table's data and formatting from the selected cells.
Only use this when you no longer need the table contents.
Undo a format you just applied
This fixes table formatting that was added moments ago.
Press Ctrl+Z on Windows or Excel for the web.
Press Command+Z on a Mac.
Select Undo in the Quick Access Toolbar or the upper-left ribbon area if you prefer the button.
Repeat Undo until the unwanted table formatting is reversed, while the action is still in Excel's undo stack.
Stop Excel from formatting new table rows
If Excel keeps extending the table style into new rows or columns, change the AutoFormat setting in Excel for Windows. Go to File, Options, Proofing, then AutoCorrect Options.
Open AutoFormat As You Type and clear Include new rows and columns in table. Excel for the web does not include this setting.
For a format Excel just applied automatically, select the AutoCorrect Options button beside the change, then choose Undo or Stop.
Clean up stubborn worksheet formatting
Use these when the normal table-style and clear-format steps do not match what is on the sheet.
If the formatting came from a cell style, select the cells, open Home, choose Cell Styles, then apply Normal.
If a custom table style is causing the look, select a table using it, open Home and Format as Table, or open Table Design and Table Styles, then delete the custom style. Tables using it return to the default table format.
If you have Copilot in Excel, select the Copilot icon in the lower-right corner of Excel, then ask it to remove table styling or banded rows for the selected table or range. In Allow editing mode Copilot changes the workbook directly, so use Plan mode to review and confirm the approach before it acts, or Chat only mode to ask without changing the workbook.
If you repeatedly clean the same kind of workbook, use Developer, Record Macro, perform the cleanup steps, then stop recording. Macros cannot be undone after running.
In Excel for Windows with Microsoft 365 Apps for enterprise plans or equivalent editions, enable the Inquire add-in under File, Options, Add-ins, then use Inquire and Clean Excess Cell Formatting to clean unused worksheet areas.
Frequently Asked Questions
Does clearing a table style remove my data?
No. Choosing Clear in the Table Styles gallery keeps the data and keeps the range as an Excel table.
Why does formatting stay after I convert to a range?
Convert to Range removes table functionality, but it leaves the visible cell formatting in place. Select the converted range and use Home > Clear > Clear Formats.
Can I clear only banded rows without removing the whole table format?
Yes. Select a cell in the table, open Table Design, and turn off Banded Rows under Table Style Options.
What is the fastest way to remove everything in the table?
Select all cells in the table and use Home > Clear > Clear All. You can also select the table and press Delete when you no longer need the data or formatting.