How can we help you?

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 t_convert_smart_table Convert.

When working in macOS, select the Data > Convert into regular range command from the command menu.

Open the context menu by right-clicking and run the Convert into regular range command.

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

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.

 

Was this helpful?
Yes
No
Previous
Select the type of calculation in the total row
Next
Delete a table