How to convert a table to a normal range in Excel 

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.