To remove table functionality (Convert to Range)

This method removes all the powerful features of an Excel table, such as structured references, filtering, and sorting. 

1. Select: any cell within the table.
2. The Table Design tab will appear on the ribbon. Click on it.
3. In the Tools group, click Convert to Range.
4. Click Yes in the pop-up window to confirm the conversion.

This video demonstrates how to remove table functionality by converting it to a range:

Share: