In this workbook, we have a number ofExcel Tables.
Let’s look at some ways you’re free to remove these tables.
You won’t find a “delete table” command in Excel.
If a table sits alone on a worksheet, the fastest way is to delete the sheet.
For example, this sheet contains a table showing the busiest airports in the world.
When I delete the sheet, the table is completely removed.
On this sheet, I want to remove the Orders table and leave the summaries.
I’ll grab the first column, then hold down the Shift key and grab the last.
Then I’ll Right-Click and Delete.
This command leaves all data and formatting in place and removes only the table definition.
To illustrate, here I have a table named “movies”.
What happens to formulas that usestructured referenceswhen you convert a table to a range?
Let’s look at an example.
In this table, the Total column is a formula that multiples quantity by price.
you could see the formula uses structured references.
To the right, another formula counts rows in the table using a structured reference.
I’ll undo back to the table, and try that now.
Under Table Styles, I’ll choose the “None” option.
