How to Undo a Table in Excel (Convert to Range)

To undo a table in Excel without losing your data, click any cell in the table, open the Table Design tab, and select Convert to Range in the Tools group. The table becomes an ordinary range of cells and every value stays where it is. If you only just created the table, pressing Ctrl+Z reverses it even faster.

Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows, and Excel for Mac (Microsoft 365, 2024 and 2021). Checked against Microsoft Support on October 6, 2026.

Before you start: what “undoing” a table changes

An Excel table is a range that Excel treats as one named object, with filter arrows in the header row, a style, and formulas that can refer to columns by name. Converting it to a range switches those table features off. According to Microsoft, this is what you lose:

• Sort and filter arrows in the header row disappear.
• Structured references, which are formula references that use table and column names such as =SUM(DeptSales[Sales Amount]), turn into regular cell references. The formulas keep working; they just point at cell addresses instead of names.
• Automatic expansion stops. Typing in the row or column next to the data no longer extends the table or its formatting.
• Banded Rows and the Total Row stop behaving as table options. They are no longer settings you can switch on and off.

Your data is not deleted, and the colors and borders from the table style can stay on the cells. Removing that leftover look is a separate step, covered below.

Convert the table to a range in Excel for Windows

1. Click any cell inside the table. The Table Design tab appears on the ribbon; it only shows while a table cell is selected.
2. Select Table Design.
3. In the Tools group, select Convert to Range.
4. If Excel asks whether you want to convert the table to a normal range, confirm it. The filter arrows vanish from the header row and the Table Design tab no longer appears when you click in the data, which tells you the table is gone.

Use the right-click menu instead

If you would rather not hunt through the ribbon, the same command is on the shortcut menu.

1. Right-click any cell in the table.
2. In the shortcut menu, point to Table.
3. Select Convert to Range and confirm if asked.

Convert a table to a range in Excel for Mac

The command is the same on a Mac, but the tab has a shorter name.

1. Click any cell inside the table.
2. Go to the Table tab on the ribbon. This is the Mac equivalent of Table Design.
3. In the Tools group, select Convert to Range.

Undo a table you just created with Ctrl+Z

If turning your data into a table was the last thing you did, you do not need Convert to Range at all. Press Ctrl+Z on Windows, or Cmd+Z on a Mac, or select Undo on the Quick Access Toolbar. Each press steps back one action, so if you have typed or formatted anything since creating the table, those edits are undone first.

Undo has limits. Microsoft lists a default of 100 undoable actions, and some things cannot be undone at all, including saving a file and commands on the File tab. Running a macro in Excel also clears the undo history. If Undo is no longer an option, use Convert to Range instead. If you step back too far, Ctrl+Y redoes the last action.

Remove the leftover table formatting

After conversion the cells can still carry the shading and borders of the table style. You have two ways to get back to plain cells.

Clear the style before you convert

1. Click any cell in the table.
2. On the Table Design tab, expand the Table Styles gallery. You can also go to the Home tab and select Format as Table.
3. Select Clear. The table is shown in the default table format, but it is still a table.
4. Now select Convert to Range in the Tools group.

Clear the formats after you convert

1. Select the cells that used to be the table.
2. On the Home tab, in the Editing group, select the arrow next to Clear.
3. Choose Clear Formats. This clears only the formats applied to the selected cells and leaves the contents in place.

Be careful with the other choices on that menu. Clear All removes the contents as well as the formats, and Clear Contents removes the values while keeping the formatting. Also keep in mind that Clear Formats clears every format on the selected cells, not only the table style, so check dates and currency amounts afterward and reapply their number formats if they changed.

Converting is not the same as deleting

If you want the table and its data gone completely, select all the cells in the table, select Clear on the Home tab, and pick Clear All. Microsoft notes you can also select the table and press Delete. Do this only when you no longer need the information; Convert to Range is the option that keeps it.

To remove only part of a table, select the rows or columns, then on the Home tab, in the Cells group, select the arrow next to Delete and choose Delete Table Rows or Delete Table Columns.

Troubleshooting

The Table Design tab is missing

The tab is contextual. It appears only after you click a cell that belongs to a table. If you click inside your data and the tab still does not show up, the cells are probably already a normal range that simply kept table-like colors. In that case use Clear Formats to remove the look.

You are using Excel for the web

Microsoft’s help for Excel for the web says that keeping the data without the table format is not something you can do there, and points you to the Excel desktop application to convert a table to a range. If you do not see the command in your browser, open the workbook in the desktop app and follow the Windows or Mac steps above. On a work or school account, whether you have the desktop app depends on what your organization provides.

Formulas look different afterward

This is expected. Microsoft states that when you convert a table to a range, all cell references change to their equivalent absolute A1 style references. A formula that used a column name now shows a fixed cell range, and that range does not grow when you add rows below it. Update those formulas by hand if you add more data later.

You converted the wrong table

Press Ctrl+Z right away to bring the table back. If it is too late for Undo, recreate it: select a cell in the data, select Home > Format as Table, choose a style, check the cell range in the Create Table dialog box, mark whether your table has headers, and select OK. Note that Excel does not turn the regular cell references back into structured references for you. Our guide on how to create a table in Excel with multiple columns and rows walks through setting one up from scratch.

Frequently asked questions

Does converting a table to a range delete my data?

No. Convert to Range removes the table features and leaves the values and formulas in their cells. Only the Clear and Delete commands remove data.

Why does my data still look like a table?

The cell shading and borders from the table style can remain after conversion. Select the cells and use Home > Clear > Clear Formats, or clear the table style before converting.

Can I remove only the filter arrows and keep the table?

Yes. On the Table Design tab, the Table Style Options group has a Filter Button check box that toggles the arrows on and off. The same group lets you turn off Banded Rows and the Header Row formatting without giving up the table.

Is this the same as a What-If Analysis data table?

No. Microsoft points out that Excel tables should not be confused with the data tables that are part of the What-If Analysis commands. The steps in this article apply to tables created with Format as Table or Ctrl+T.

What is the shortcut to create a table again?

On Windows, Ctrl+T or Ctrl+L opens the Create Table dialog box. On a Mac, use Cmd+T or Control+T.

For Microsoft’s own reference, see Convert an Excel table to a range of data and Clear cells of contents or formats. Once the table is gone, check any formulas that pointed at it so they still cover all of your rows.