Convert a table to a regular range

To convert a table to a regular range with data, follow these steps:

1. Select the table cell or range of cells.

2. Run the conversion command in one of the following ways:

   • On the Home tab, in the Table group, click  Convert table into regular range.
   • Open the context menu by right-clicking and run the Convert into regular range command.

3. In the Table window that opens, click Convert.

tip

When converting a table to a regular range, the autofilters in the table headers will be removed and any rows/columns hidden by grouping will be displayed.