How to Remove Table Formatting in Excel (4 Quick Methods)

Method 1: Convert the Table to a Regular Range (Ribbon)

This is the cleanest way to remove the table object itself. Place your cursor anywhere inside the table so Microsoft Excel knows which one you mean. A green Table Design tab (labeled Table Tools > Design in older versions on Windows) appears at the top of the window. Open it, find the Tools group, and click Convert to Range. Excel asks for confirmation. Click Yes.

The data stays exactly where it was, but the filter buttons vanish, the structured references go away, and the range stops adding new rows automatically when you type below it. At this point, the cells still carry whatever fill colors and borders the table style applied, so move on to clearing the formatting if you want a plain look.

Method 2: Clear or Change the Table Style (Keep the Table)

When you like the filtering and totals features but dislike the colors, you can strip the table style formatting while leaving the data intact. Click a cell in the table, open the Table Design tab, and in the Table Styles gallery click Clear to remove the formatting while keeping the table. You can use the More arrow in the bottom-right corner of the gallery if needed. The banded rows and colored header disappear, while the table keeps working as a table.

An equivalent option is to scroll to the top-left of the same table styles gallery and pick the None style, which produces the same plain result. To control an individual table element, use the Table Style Options group on the same tab. Unchecking Header Row, Banded Rows, First Column, or Total Row removes those pieces of the style one at a time. If you later want a tidy look of your own, click New Table Style at the bottom of the gallery to create a custom table style and store it for reuse. This approach is ideal for data you still need to filter or sort, since it preserves every table feature and changes only the appearance.

Method 3: Right-Click Context Menu

Many people find the right-click route quicker than hunting through ribbon tabs. Right-click any cell in the table, hover over Table in the menu that appears, and choose Convert to Range from the submenu. Click Convert to confirm the prompt, and the new table becomes a standard range. As with the ribbon method, the cell colors remain until you clear them, so finish with Home > Clear > Clear Formats if you want a blank canvas.

The right-click path is handy on laptops where the ribbon is collapsed or on shared machines where the layout has been customized.

Method 4: Clear All Formatting at Once

Sometimes the goal is broader than tables. You may have inherited a worksheet with random fills, bold fonts, borders, and number formats that all need to go. Select the cells you want to reset (or press Ctrl + A to select every column and the rows around it), then open the Home tab, find the Editing group on the far right, and click the eraser icon labeled Clear. Choose Clear Formats.

If you want to delete the table completely instead, select the entire table and press the Delete key, which removes the contents and leaves blank rows in the worksheet.

The Clear Formats command removes every visual format from the selection at once: fills, font styles, borders, alignment, and number formatting. The data and any formulas stay in place, and nothing is deleted from the cells. Note that Clear Formats also resets number formatting, so currency symbols, percentages, and date displays revert to plain numbers. If you only meant to remove formatting such as color, the table-specific methods above are safer.

Keyboard Shortcuts

Excel has no single dedicated shortcut that removes table formatting, though the keyboard speeds up the steps. To open the table conversion option, press Alt, then J, then T to jump into the Table Design tab, and follow the underlined letters Excel shows for each button to finish the command. For clearing formats, there is no default key combination, although you can add Clear Formats to the Quick Access Toolbar for one-tap access and trigger it with Alt plus its position number. Power users who repeat this task often assign it a custom shortcut through a macro, which leads to the next method.

The VBA / Macro Approach (For Repeat Jobs)

If you remove a table from many sheets every week, a short macro saves real time. Press Alt + F11 to open the Visual Basic editor, insert a new module, and paste a routine that loops through the tables on a worksheet and unlists them. A common one-line core uses ActiveSheet.ListObjects(1).Unlist to convert the first table to a range, optionally followed by a line that clears the cell formatting. Save the workbook as a macro-enabled file (.XLSM) and run the macro whenever you need it. The macro is stored inside the workbook, so it travels with the file.

This is the only method here that touches code, and it suits people comfortable recording or editing macros. Everyone else can stay with the ribbon and right-click options above.

Common Issues and Troubleshooting

The colors stayed after the table was converted. This is expected. Converting to a range removes table behavior, not the fill. Select the cells and use Home > Clear > Clear Formats to remove the banding and header color.

Alternating row colors will not go away. Those rows were likely styled with conditional formatting rather than a table. Select the range, open Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells, and the stripes disappear.

Filter buttons are still showing. If a small dropdown arrow remains in the header row after the table is removed, an active filter is probably still on the range. Open the Data tab and click Filter to toggle it off.

Clear Formats also removed the dates and currency. Clearing formats resets number formatting along with colors. Reapply the number format you need from the Home tab, or undo with Ctrl + Z and use a table-specific method that leaves number formats untouched.

The table keeps coming back when you type next to it. That is the table auto-expand feature creating new rows. Once you convert to a range, this stops. If it persists, confirm the conversion actually completed by checking that the Table Design tab no longer appears when you click the data. A missing Table Design tab means the conversion worked.

Everything needs to go, even the data layout. If the current setup is beyond cleanup, one practical idea is to start over in a fresh sheet and copy only what you need. This leaves you with raw data and zero formatting of any kind. Running the convert step a second time is never needed once the data is plain.

For Developers: Removing Table Formatting in Code

When this cleanup needs to happen automatically, inside a reporting pipeline or a batch job that processes hundreds of files, doing it by hand in Excel is impractical. The IronXL library lets a .NET application open an Excel file and target the range to clean without Microsoft Excel installed on the machine. The example below loads an Excel workbook, strips the fill and borders from a range, and saves a clean copy of the file; if a developer later needs to recreate the look first, they can apply Format as Table before clearing or replacing it.

using IronXL;
using IronXL.Styles;
using System.Linq;
// Load the workbook that contains the styled table
WorkBook workBook = WorkBook.Load("report.xlsx");
WorkSheet workSheet = workBook.WorkSheets.First();
// Target the range that holds the table styling
var range = workSheet["A1:D20"];
// Remove the fill used for banded rows and the header
range.Style.SetBackgroundColor("#FFFFFF");
// Remove the table borders
range.Style.TopBorder.Type = BorderType.None;
range.Style.BottomBorder.Type = BorderType.None;
range.Style.LeftBorder.Type = BorderType.None;
range.Style.RightBorder.Type = BorderType.None;
workBook.SaveAs("report-clean.xlsx");

using IronXL;
using IronXL.Styles;
using System.Linq;
// Load the workbook that contains the styled table
WorkBook workBook = WorkBook.Load("report.xlsx");
WorkSheet workSheet = workBook.WorkSheets.First();
// Target the range that holds the table styling
var range = workSheet["A1:D20"];
// Remove the fill used for banded rows and the header
range.Style.SetBackgroundColor("#FFFFFF");
// Remove the table borders
range.Style.TopBorder.Type = BorderType.None;
range.Style.BottomBorder.Type = BorderType.None;
range.Style.LeftBorder.Type = BorderType.None;
range.Style.RightBorder.Type = BorderType.None;
workBook.SaveAs("report-clean.xlsx");

Imports IronXL
Imports IronXL.Styles
Imports System.Linq

' Load the workbook that contains the styled table
Dim workBook As WorkBook = WorkBook.Load("report.xlsx")
Dim workSheet As WorkSheet = workBook.WorkSheets.First()

' Target the range that holds the table styling
Dim range = workSheet("A1:D20")

' Remove the fill used for banded rows and the header
range.Style.SetBackgroundColor("#FFFFFF")

' Remove the table borders
range.Style.TopBorder.Type = BorderType.None
range.Style.BottomBorder.Type = BorderType.None
range.Style.LeftBorder.Type = BorderType.None
range.Style.RightBorder.Type = BorderType.None

workBook.SaveAs("report-clean.xlsx")

The same library handles related cleanup tasks such as clearing cell contents while keeping the layout, removing conditional formatting rules, and trimming empty rows; in code, that can also include resetting values tied to fill tabs for styled table areas.

Wrapping Up

Removing table formatting in Excel comes down to deciding what you want to keep. Convert to a regular range when you want the table functionality gone, clear the table style when you want to keep the filters but lose the colors, and use Clear Formats when you want a completely plain worksheet. The right-click menu and a quick macro give you faster routes for the jobs you repeat. For the trickier cases, the troubleshooting tips above cover the surprises that catch most people, especially the leftover colors and the conditional formatting stripes.