How to convert a table to a normal range in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-convert-a-table-to-a-normal-range-in-Excel-.png)
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 an occasion when you have received a file in which the data has been defined as a table but you do not want to keep it as such. In this case, you have the option to convert the table back into a range of cells.
Step 1 – Select the table
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-convert-a-table-to-a-normal-range-in-Excel-.png)
– Select the table
Step 2 – Convert to Range
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-convert-a-table-to-a-normal-range-in-Excel-.png)
– Go to Table Design > Tools
– Click on Convert to Range
Step 3 – Confirm the conversion
![](https://spreadcheaters.com/wp-content/uploads/Step-3-–-How-to-convert-a-table-to-a-normal-range-in-Excel-.png)
– On the pop-up warning, click OK
Step 4 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Step-4-–-How-to-convert-a-table-to-a-normal-range-in-Excel-.png)
– The in-column filters disappear
– The Table Design menu disappears