How to remove a table from 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:
- Removing the Table and the data
- Removing the Table definition and keeping the data as a range
Option 1 – Remove 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