Converting a List to a Table
Converting a list to a table makes it very easy to format your data and to keep the formatting consistent as you make changes to the data. To convert a list to a table:
- Select a cell within the list you wish to convert to a table.
- On the INSERT tab, in the Tables group, click the Table command:
- In the Create Table dialog box, verify that Excel has correctly guessed the correct data range, check My table has headers if your table does have headers, and click OK: