How to get rid of a table in Excel

You can watch a video tutorial here.

Excel has the provision to define a set of data as a Table. This is a useful feature especially when you need to create totals and calculated columns. It also becomes easy to add data and reference data when it is defined as a table. There may be a situation where you do not want the table. Here we will look at 2 scenarios:

1. You want to get rid of the Table and the data
2. You want to get rid of the Table definition and keep the data as a range

Option 1 – Get rid of the table and the data 

Step 1 – Delete the table

• Select the table
• Go to Home > Cells > Delete > Delete Table Rows

OR

Go to Home > Cells > Delete > Delete Table Columns

OR

Right-click for the context menu and click Delete > Table Columns

OR

Right-click for the context menu and click Delete > Table Rows

OR

Press Delete on the keyboard

Step 2 – Check the result

• Check that the table has been deleted

Option 2 – Get rid of the table and keep the data

Step 1 – Select the table

• Select the table

Step 2 – Convert to Range

• Go to Table Design > Tools
• Click on Convert to Range

Step 3 – Confirm the conversion

• On the pop-up warning, click OK

Step 4 – Check the result

• The in-column filters disappear
• The Table Design menu disappears