How to Undo a Table in Excel: Simple Revert Steps

Excel tables (the structured ranges with filter arrows and banded rows) are handy for sorting and formulas, but sometimes you just want the plain range back. This guide shows you how to convert a table back to a normal cell range, keeping all your data, formatting, and formulas intact. You only need the workbook open; no special add-ins are required.

What You’ll Need

• Microsoft Excel (2010 or newer; the steps are identical in Excel for Microsoft 365, Excel 2021, 2019, and 2016).
• The workbook containing the table you want to undo.
• Optional: a backup copy of the file if the data is critical (though the process is reversible and safe).

Step-by-Step

1. Open the workbook and navigate to the worksheet that holds the table.
2. Click anywhere inside the table. You don’t need to select the whole range; a single cell inside the table is enough. When you do, the Table Design tab (called Table Tools Design in older versions) appears in the ribbon.
3. Look at the ribbon. You’ll see a new tab labeled Table Design (or Design). Click that tab.
4. Find the Tools group. On the left side of the Table Design tab, there is a group called Tools. Inside it, click the button labeled Convert to Range. It has a small icon that looks like a grid with a corner arrow.
5. Confirm the prompt. Excel will ask: “Convert table to a normal range?” Click Yes. (If you click No, nothing changes.)
6. Check the result. The filter arrows disappear from the header row, the blue table borders are gone, and the banded row shading (if you had it) is removed. Your data, formulas, and any cell formatting you applied manually remain exactly as they were.
7. Optional: remove leftover formatting. If the table had banded rows or a specific table style, the colors may vanish automatically. If you want to keep the visual style, you can reapply it later using Format as Table again (which recreates a table) or by manually filling cells. To fully strip any remaining fill color, select the range, go to Home > Fill Color > No Fill.

Common Mistakes

• Selecting the entire column instead of a cell inside the table — this still works, but clicking a single cell is faster and less error-prone.
• Using the right-click menu incorrectly. Right-clicking a cell inside the table and choosing Table > Convert to Range also works, but many users miss the submenu and click Delete instead, which removes the table and its data. Stick with the ribbon button if you’re unsure.
• Thinking the data is deleted. Converting to range never deletes data. If your data disappears, you likely accidentally pressed Delete on a selected column — use Undo (Ctrl+Z) immediately.
• Expecting formulas to change. Structured references like =SUM(Table1[Amount]) become normal cell references like =SUM(A2:A100) after conversion. This is normal and does not break your calculations.

Tips

• Use keyboard shortcuts: After clicking inside the table, press Alt, then J, then T, then R (this navigates to Table Design > Convert to Range). Then press Enter to confirm.
• Convert multiple tables at once: Hold Ctrl and click a cell in each table, then follow the same steps. Excel will ask for confirmation for each one.
• Keep the filter arrows: If you only want to remove the table style but keep filtering, convert to range, then select the header row and use Data > Filter to re-add the arrows manually.
• Before converting, copy the table to another sheet if you think you might need the table structure later. Paste it as a table (or just keep the original and convert the copy).
• Check named ranges: If you used the table name in formulas, those formulas will still work after conversion because Excel updates the references automatically. However, any named range that pointed to the table’s columns will now point to the absolute range (e.g., =Sheet1!$A$2:$A$100), which is fine unless you insert rows outside the range.

Troubleshooting

• The “Convert to Range” button is grayed out: This happens when you haven’t clicked inside the table. Click any cell within the blue-bordered table area, then check the ribbon again.
• You don’t see the Table Design tab: If you’re on a Mac, the tab is called Table Design as well, but it may be hidden if the window is narrow. Click the table, then look at the top menu bar — it should appear. If not, try right-clicking the table and choosing Table > Convert to Range.
• The table is actually a PivotTable: If your “table” has a PivotTable Analyze tab instead of Table Design, it’s a PivotTable, not a regular table. To remove a PivotTable, select it, go to PivotTable Analyze > Select > Entire PivotTable, then press Delete. This removes the pivot but leaves the source data intact.
• After converting, the filter arrows are still there: This can happen if you had manually added filters to the range before converting. Go to Data > Filter to toggle them off.
• Formulas show #REF! errors after conversion: This is rare but occurs if you had a formula that referenced the table by name and the conversion somehow broke the reference. Use Ctrl+Z to undo the conversion, then re-check the formula. If it persists, replace the structured reference with the actual cell range manually.
• You accidentally deleted the table instead of converting: Press Ctrl+Z (Undo) immediately. If you’ve closed the file, reopen it and check the version history (File > Info > Version History) to restore the previous version.

Frequently Asked Questions

Q: Will converting a table to a range delete my data?
A: No. The conversion only removes the table structure (filter arrows, banded rows, table name). All cell values, formulas, and formatting remain exactly as they were.

Q: Can I undo the conversion if I change my mind?
A: Yes, press Ctrl+Z immediately after converting. If you’ve done other actions since, you can re-select the range and go to Insert > Table (or Home > Format as Table) to create a new table from the same data.

Q: Will my formulas that used the table name still work?
A: Yes. Excel automatically rewrites structured references (like Table1[Column1]) to normal cell references (like $A$2:$A$100) during the conversion. The calculated results stay the same.

Q: Does converting affect sorting or filtering I applied?
A: The filter arrows disappear, but any sort order you applied to the data remains. If you had a custom sort, the rows stay in that order. You can re-add filters manually if needed.

Q: Can I convert only part of a table to a range?
A: No. The conversion applies to the entire table. If you want to keep part of it as a table, copy that part to a new location and convert the original, or split the table manually by copying rows to a new range.

Q: What’s the difference between “Convert to Range” and “Unlink” (for imported data)?
A: “Convert to Range” is for Excel tables you created. “Unlink” appears when you right-click a table that came from an external data connection (like Power Query). Unlink removes the connection but keeps the data as a normal range. They are different operations; use the one that matches your situation.

Related

• Remove Adobe Genuine Software Integrity Service
• Fix Samsung Galaxy Note 8 Camera Failed Error
• Undo and Redo Changes in Excel: Quick Guide