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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. For “delete table format 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. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. Treat “delete table format excel” as a small building block rather than a chore. Once the inputs sit in their own cells and the formula reads from them, the same setup answers a dozen related questions with a tweak, and Excel keeps every dependent figure current as the data changes. The tool above is there so you can rehearse and verify before committing anything to a real workbook; the steps and worked example are there so the logic sticks. Get it right once and it stops costing you time — it starts saving it, every time the question comes back around.
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.