How can we help you?
Convert a table to a regular range
Product:
Application:
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:
•In the Data menu, select Convert into Regular Range.
•On the Toolbar, in the Table section, click 
Convert Table into Regular Range.
•Open the context menu by right-clicking and run the Convert Table into Regular Range command.
•Select Convert Table into Regular Range in Quick Actions box.
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
