The Format as Table feature converts the selected cell range into a table. It utilizes Excel’s standard functionality, equivalent to selecting a range and choosing Format as Table from the Home tab. You can select from 43 table designs for your table format.
Target Data
Data Range: Identify the cells range where you want to apply the function.
Table Type: Select the one you want to delete.
Specify the starting cell where the results will be placed.