Skip to main content

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​

  1. Right-click any cell within the smart table.
  2. 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.