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