To convert a smart table to a regular range with data:
1.Select any cell within the table.
2.Use one of the following methods:
•On the Home tab, in the Smart Table group, click Convert table into regular range.
•From the context menu, select Convert into regular range.
After converting the table, auto filters will be removed and all hidden rows and columns will be displayed.