Convert an Excel table to a range of data

You can remove an Excel table by converting it to a range of data.

1. Click anywhere in the table.

   Tip This displays the Table Tools, adding the Design tab.

2. On the Design tab, in the Tools group, click Convert to Range.

   

   Tip You can also right-click the table, point to Table, and then click Convert to Range.

Tip You can also click Undo on the Quick Access Toolbar to convert a table that you just created from a range.