Delete an Excel Table but Keep the Data

To delete an Excel table but keep its data, convert the table to a normal range: click inside it, choose Table Design > Tools > Convert to Range, then confirm. The cell values remain in place; the table’s special features, such as its structured behavior and automatic expansion, are removed.

What “delete a table” means in Excel

Excel uses “table” to describe a specific feature, not just a block of cells with headings and borders. A formatted table has a name, filter controls, structured references, and behavior that helps it expand when you add rows or columns. A plain range can look similar, but it does not have those table-specific capabilities.

That distinction matters because there are several different actions people may mean by “delete.” Converting a table to a range removes the table object while preserving the cell contents. Clearing contents removes values or formulas but leaves the cells and possibly their formatting. Deleting rows or cells removes worksheet data and can shift other cells. If your goal is to keep the information and stop using table features, conversion is the right choice.

Convert an Excel table to a range on Windows

In Excel for Microsoft 365 on Windows, use these steps:

Click any cell inside the table. The contextual Table Design tab appears on the ribbon.
Open Table Design and find the Tools group.
Select Convert to Range.
When Excel asks whether you want to convert the table to a normal range, choose Yes.

The data stays in the same worksheet cells, so the conversion does not move the table or create a separate copy. If you do not see Table Design, first check that the selected cell is actually inside an Excel table rather than an ordinary formatted range. You can also click the table and look for its table name or contextual tab.

On Excel for Mac, click inside the table and use the contextual Table tab to find Convert to Range; the tab and ribbon layout can differ from Windows. Excel for the web also provides table-conversion controls when a table is selected, though the ribbon layout may vary. If you cannot locate the command, confirm that the selection is within the table and look for the contextual table tab.

What stays after conversion

Conversion keeps the data cells where they are. Text, numbers, dates, and formulas are not intentionally cleared by this command. The existing cell formatting, including much of the table’s banded-row or header styling, may remain as ordinary formatting. That means the converted range can still look like a table even though it no longer behaves like one.

For example, imagine a table with columns named Product, Quantity, and Price. Converting it to a range leaves those headings and all product records in their original cells. If the table used a blue header and alternating row colors, those colors can remain. You may need to remove or adjust the formatting separately if you want a plain-looking range.

What table features you lose

After conversion, Excel no longer treats the cells as a named table. The table’s automatic expansion and table-specific tools are no longer available. New entries below the range will not automatically become part of a table, and the table name cannot be used as a table object in the same way.

Structured references: Formulas that use table names or column names may be changed or may need attention. Inspect important formulas after conversion, especially formulas elsewhere in the workbook that refer to the table.
Table filters: The table’s filter controls are no longer part of a table. If you still need to filter the data, select the range and use Data > Filter to apply ordinary range filters.
Automatic table behavior: New rows and columns do not inherit table formulas, formatting, or other table behavior automatically.
Table name and table-only options: Features that depend on the table object, such as selecting it by its table name, are no longer available after conversion.

Do not assume every formula will be unaffected just because the visible values remain. For a workbook with reports, formulas, or charts linked to the table, check those dependencies before treating the conversion as finished.

Keep the data but remove the table’s appearance

Converting to a range and removing its appearance are separate tasks. Excel may retain the table’s colors and borders as normal cell formatting, so the range can still look table-like. To remove that styling, select the converted cells and choose Home > Clear > Clear Formats. This removes formatting, not values or formulas. Review the selection first: applying Clear Formats to an oversized area may remove useful number formats, fonts, and borders too.

If you want to keep only some styling, use the formatting controls on the Home tab to change the header fill, borders, or banded rows selectively. Avoid choosing Clear All when your goal is to preserve data, because it removes contents as well as formatting. A useful approach is to convert the table first, then format the range deliberately.

Alternatives when you want different results

Choose the action based on what you want to retain. The options are not interchangeable:

Keep everything but remove table behavior: Use Convert to Range.
Keep the cells but erase their contents: Select the relevant cells and press Delete on Windows. On a Mac, the Delete key may be labeled Backspace; use the keyboard key that clears cell contents, or use Home > Clear > Clear Contents.
Remove the data and shift other cells: Select the table rows or cells and use the appropriate delete command. This changes the worksheet layout, so check nearby data first.
Keep the table but remove its colors: Use the table style options to choose a plain style or turn off banded rows, rather than converting it.
Keep a backup copy: Copy the table to another sheet or save a separate workbook before making a change that affects important formulas or reports.

Pressing Delete is not the same as deleting the table object. It clears the selected cell contents, while the table structure may remain. Likewise, deleting a table’s worksheet rows is not the same as converting it to a range; row deletion can remove the data you meant to keep.

Check the workbook before and after

For a small, independent list, conversion is usually straightforward. In a workbook used for reporting or shared with other people, take a minute to check how the table is connected to the rest of the file. Tables are often used as sources for formulas, charts, PivotTables, or data-validation lists. A range may still contain the same records, but references or refresh behavior that depended on the table could need updating.

Save the workbook or create a copy before changing a table that supports important work.
Note the table name and any formulas that use it, particularly in summary sheets.
Convert the table, then inspect formulas for errors and verify key totals or reports.
Check whether filter controls are still available. If not, select the data and apply Data > Filter if needed.
Add a test row only if appropriate to confirm that the range behaves as you expect; unlike a table, a normal range will not automatically extend table features.

Excel’s Undo command can reverse a recent conversion if you notice a problem immediately. For important workbooks, a saved copy is a safer fallback than relying only on Undo, especially if you continue editing afterward.

Frequently Asked Questions

Will converting an Excel table to a range delete the data?
No. Convert to Range removes the table structure, not the values and formulas in its cells. Check linked formulas and reports afterward because table-dependent references may be affected.

Why does my converted range still look like a table?
Excel can retain the table’s colors, borders, and other cell formatting as ordinary formatting. Use Home > Clear > Clear Formats if you want to remove that appearance without clearing the cell contents.

Can I still filter the data after converting it?
Yes. Select the range and choose Data > Filter to use ordinary range filters. The table’s own controls and table behavior are no longer present, but filtering is still possible.

Does pressing Delete remove an Excel table?
No. Pressing Delete generally clears the selected cells’ contents; it does not necessarily remove the table object. To keep the contents while removing the object, use Convert to Range.

Can I turn the range back into a table later?
Yes. Select a cell in the range and use Insert > Table, then confirm the range and whether it has headers. Review the result, since recreating a table does not necessarily restore its old name, settings, or connections automatically.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.