How to Convert a List to a Table in Microsoft Excel

See Microsoft Excel: Tips and Tricks for similar articles.

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. You can convert a list to a table in three short steps.

This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.

  1. Select a cell within the list you wish to convert to a table.
  2. On the Insert tab, in the Tables group, click the Table command. Table Command
  3. 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. Create Table Dialog Box