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
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-1-–-How-to-remove-a-table-from-Excel-1024x532.png)
- 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
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-2-–-How-to-remove-a-table-from-Excel.png)
- Check that the table has been deleted
Option 2 – Get rid of the table and keep the data
Step 1 – Select the table
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-1-–-How-to-remove-a-table-from-Excel.png)
- Select the table
Step 2 – Convert to Range
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-2-–-How-to-remove-a-table-from-Excel-1024x761.png)
- Go to Table Design > Tools
- Click on Convert to Range
Step 3 – Confirm the conversion
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-3-–-How-to-remove-a-table-from-Excel-1024x509.png)
- On the pop-up warning, click OK
Step 4 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-4-–-How-to-remove-a-table-from-Excel.png)
- The in-column filters disappear
- The Table Design menu disappears