Remove a table without formatting
In this lesson, I’ll show you how you can remove a table.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/excel-table-example-no-formatting.png)
If you haven’t applied any formatting to your table, just a table style, you have to select all the cells. You can do it in a few different ways:
- Select all the cells inside a table by dragging.
- Click header and press Ctrl + A.
- Click non-header cell, and press Ctrl + A twice.
Now, press the Delete button and the table will disappear.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/no-table.png)
Remove a table with formatting
You cannot do the same with a table, to which you applied formatting.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/excel-table-example.png)
If you try to delete it in the same way the formatting is going to stay.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/no-table-formatting.png)
In this case, it would be better if you select all the cells, as you did in the previous example and navigate to Home >> Editing >> Clear >> Clear All.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/clear-all.png)
Now, the result is the same as before.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/no-table-1.png)
Remove a table by converting to range
Maybe, you just want to delete the table, but want to keep the data inside a table. In this case, you just want to convert your table to a range.
In order to do it, click any cell inside a table and navigate to Table Tools >> Design >> Tools >> Convert to the range.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/convert-to-a-range.png)
Now, if you check your table, the data stays, but all table filtering options are gone.
![](https://officetuts.net/excel/wp-content/uploads/sites/2/2019/08/table-converted-to-range.png)