In Excel: click inside the table and choose Table Design ▸ Convert to Range to keep the data as a normal range, or select the whole table and press Delete (or Home ▸ Clear ▸ Clear All) to remove the data too.
Click any cell inside the table so the contextual Table Design tab appears.
To keep the data, choose Table Design ▸ Convert to Range (or right-click ▸ Table ▸ Convert to Range) and confirm.
The table style stays as static formatting; remove it with Home ▸ Clear ▸ Clear Formats if you want plain cells.
To delete everything instead, press Ctrl+A twice inside the table to select it including headers, then Home ▸ Clear ▸ Clear All.
Check formulas afterwards: converting rewrites Table1[Sales] to cell references, while deleting the table turns them into #REF! errors.
What this does
Removing a table means one of two different things, and Excel has a separate path for each. Convert to Range keeps every value and formula but strips the table behavior: filter buttons, auto-expansion and the table name disappear, and structured references such as =SUM(Table1[Sales]) are rewritten to plain cell references like =SUM(B2:B6). Deleting the table removes the data as well: select it and press Delete to clear the contents, or use Home ▸ Clear ▸ Clear All to wipe values and formatting in one step. Note that Convert to Range leaves the banded table style behind as static formatting. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “remove a table from excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
Table1 sits in A1:B6 with headers Month and Sales, and E1 contains =SUM(Table1[Sales]), showing 4700. Click any cell in the table, open Table Design ▸ Convert to Range and confirm. The filter arrows vanish, E1 now reads =SUM(B2:B6) and still shows 4700, and the striped rows remain until you select A1:B6 and choose Home ▸ Clear ▸ Clear Formats. Tables add filter buttons, auto-expansion and structured references you may not want when handing over a simple sheet, pasting into another system, or building layouts a table would fight against. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “remove a table from excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Expecting Convert to Range to remove the striped formatting — the style stays until you clear formats.
- Pressing Delete on the contents and assuming the table is gone; the empty table object and its name still exist.
- Looking for the Table Design tab without first clicking inside the table — it only appears for the active table.
- Deleting a table that other formulas reference by name, which leaves
#REF!errors instead of converted references. - Confusing deleting a table with deleting the worksheet tab that contains it.
Frequently asked questions
Does Convert to Range delete my data?
No. All values and formulas stay in place; only the table behavior (filters, name, structured references, auto-expansion) is removed.
What happens to =Table1[Sales] formulas?
Convert to Range rewrites them to ordinary references such as =SUM(B2:B6). Deleting the table instead breaks them with #REF!.
How do I remove a table in Google Sheets?
For the newer Sheets tables, open the menu next to the table name and convert it to an unformatted range. If it is just banded formatting, use Format ▸ Alternating colors ▸ Remove.
Other ways people ask this
People reach this page typing “how to remove table from excel”, “remove table from excel”, “removing table from excel” and “remove tables from excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Why do people search for this in so many different ways?
Because the same task has many names. “how to remove table from excel”, “remove table from excel”, “removing table from excel” all point at the one operation explained on this page, which is why they all lead here.