Convert smart table into regular range
You can convert a smart table into a regular range. After conversion, any table-specific autofilters will be removed and all hidden rows and columns will be displayed.
Convert a smart table to a regular range
- Right-click any cell within the smart table.
- In the context menu, select Convert into regular range.
You can also use the Convert table into regular range tool on the Home tab, in the Table group.