How To Remove a Table in Excel

Last updated: August 19, 2026

There are three different jobs hiding behind the phrase "remove a table in Excel", and picking the wrong one is how people lose work. You might want the data to survive but the table object to go. You might want the table to stay but the blue banded stripes to go. Or you might want the whole block gone. This guide separates the three and shows what each one actually does to your worksheet.

How to Convert a Table Back to a Range in Excel

Converting to a range is the right choice when you want to keep every value and formula but stop Excel treating the block as a table object. Nothing moves and nothing is deleted.

Step 1: Open your file and select the table

Open your Excel file, then click any single cell inside the table. You do not need to highlight the whole block. One cell is enough to tell Excel which table you mean.

Step 2: Go to the Table Design tab

The Table Design tab appears on the ribbon automatically as soon as the cursor is inside a table. On Mac the same tab is labelled Table.

Step 3: Click Convert to Range

In the Tools group under Table Design, click Convert to Range. A confirmation dialog appears.

Faster route: right-click any cell in the table, choose Table, then Convert to Range.

Step 4: Confirm the action

Click Yes. The filter arrows, the table name and the structured references all disappear. Every cell and every value stays. Microsoft documents the same procedure in its official guide to converting an Excel table to a range of data.

If you converted the wrong table, press Ctrl + Z immediately. Undo restores the table object intact, but only within the current session.

Rule of thumb: Convert to Range removes the table, not the formatting. If you want clean, unstyled cells, clear the style first and convert second.

Why Do the Table Colours Stay After Converting to Range?

This is the single most common complaint after a conversion, and it is not a bug. When you convert a table to a range, Excel takes whatever the table style was painting on screen and bakes it into the cells as ordinary manual formatting. The table is genuinely gone. The blue header row and the alternating stripes are now just fill colours you applied by hand, which is why they survive.

There are two ways to deal with it, and the order matters.

The clean method: clear the style before you convert

1. Click any cell in the table.
2. Go to Table Design and open the Table Styles gallery.
3. Click the More arrow at the bottom right of the gallery, then click Clear at the foot of the menu. The table goes plain white.
4. Now click Convert to Range. There is no style left to bake in, so you get unformatted cells.

The repair method: fix it after the fact

If you already converted and you are stuck with stripes, select the range and go to Home > Clear > Clear Formats. Be aware this is a blunt instrument. It removes your fill colours and borders, but it also strips number formats, so currency and date columns will revert to raw numbers and serial dates. If that matters, remove the fills manually instead with Home > Fill Color > No Fill and Home > Borders > No Border, which leaves number formatting alone.

How to Remove Table Formatting Without Removing the Table

Plenty of people do not want the table gone at all. They want the filtering, the auto-expanding formulas and the structured references, but not the corporate blue stripes. That is a different job from converting to a range, and it takes about four seconds.

Clear the table style

1. Click anywhere inside the table so Table Design appears.
2. Open the Table Styles gallery and click the More arrow at its bottom right corner.
3. Click Clear at the bottom of the dropdown.

The table keeps every one of its powers. Only the paint is gone. This is also the answer to "how do I unformat a table" and "how do I remove the table design", which are the same operation under different names.

Turn off individual style elements instead

If you want to keep most of the style and kill one specific part of it, use the Table Style Options group on the same tab rather than clearing everything. Untick Banded Rows to lose the alternating stripes, untick Header Row to lose the coloured header, untick Filter Button to lose the dropdown arrows. Each is an independent switch.

Set a plain default so new tables are not styled

If you create tables constantly and always end up clearing them, open the Table Styles gallery, right-click the plain None or light style you prefer, and choose Set As Default. Every new table in that workbook starts unstyled.

Rule of thumb: Clear Style changes how the table looks. Convert to Range changes what the table is. Neither one deletes a single value.

How to Delete a Table Completely in Excel

If the data itself is unwanted, delete the whole block. This is the only method on this page that destroys content, so check twice before you press the key.

Step 1: Select the entire table

• Click any cell inside the table, then press Ctrl + A once to select the data body, or twice to include the header row, or
• Drag across the full table range, or
• Hover over the top left corner of the table until the cursor becomes a diagonal arrow, then click.

Step 2: Choose how much to remove

Pressing Delete clears the contents but leaves the table object and its formatting sitting there as an empty shell. That surprises a lot of people. Pick the option that matches what you actually want:

• Contents only: select the table and press Delete.
• Contents and formatting, table object still there: Home > Clear > Clear All.
• Everything including the table object and the cells: select the entire rows the table occupies, right-click a row number, and choose Delete. Only do this if nothing else lives on those rows.

Why Is Convert to Range Greyed Out or Missing?

If the button is dimmed, or the Table Design tab never appears, something is blocking the conversion. Work down this list.

What Breaks When You Convert a Table to a Range?

Convert to Range keeps every value, so nothing is lost in the sense of data. But an Excel table is doing a lot of quiet work, and that work stops. Here is what changes the moment you confirm the dialog.

Rule of thumb: Convert to Range never loses data, but it does freeze every range that used to grow by itself. Check your pivot tables and any cross-sheet formulas afterwards.

How to Remove Filter Buttons from a Table in Excel

If the table and its styling are fine and the only problem is the dropdown arrows in the header row, you do not need to convert anything.

1. Click any cell inside your table.
2. Go to the Table Design tab.
3. In the Table Style Options group, untick the Filter Button box.

The arrows disappear and the table keeps working normally. Note that hiding the buttons does not clear a filter that is already applied, so rows hidden by an active filter stay hidden and you now have no visible way to unhide them. Clear the filter before you untick the box. If some of your rows have already vanished, our guide on how to clear filters in Excel walks through getting them back.

How to Remove Several Tables or Every Table in a Workbook

Excel has no built-in "convert all tables" command, so a workbook inherited from someone else can mean a lot of repetitive clicking. Two practical approaches:

Find every table first

Open Formulas > Name Manager and filter the list to tables. Every table in the workbook is listed there with its sheet and range, which gives you a checklist rather than hunting sheet by sheet. Click an entry and Excel jumps to it.

Convert them one at a time, quickly

Once you know where they are, the fastest manual loop is: click inside the table, press Alt then J then T then G on Windows to trigger Convert to Range, then press Enter to confirm. That is four keystrokes per table with no mouse. Repeat down your Name Manager list.

If the workbook has dozens of tables and you are comfortable with macros, a short VBA loop over ActiveWorkbook.Worksheets calling .ListObjects(i).Unlist converts them all in one pass. Save a copy of the file first, because Unlist cannot be undone once the macro has finished.

Removing Tables in Excel Mobile (iOS and Android)

The mobile apps expose fewer commands, but Convert to Range is there.

1. Tap a cell in the table.
2. Tap the ribbon or the pencil icon, then choose the Table menu.
3. Scroll down and tap Convert to Range.

Clearing a table style is not available on mobile. If you need to strip the formatting as well, do the conversion on a desktop or in Excel for the web instead.

Which Method Should You Use?

Final Thoughts

Almost every problem in this area comes from mixing up two separate things: the table object and the table formatting. Convert to Range removes the object and leaves the paint behind. Clear Style removes the paint and leaves the object. Doing both, in that order, is what gets you plain data. And nothing here except the Delete key touches your values, so if the numbers vanished, it was a filter or a hidden row rather than the conversion.

Frequently Asked Questions (FAQ)

Related Blog Posts

How to Clear Filters in Excel

How to Make a Table in Google Sheets

How to Create a Training Tracker in Google Sheets

How to Create a Training Tracker in Excel