How to Convert a List to a Table in Microsoft Excel

  • google plus

In Brief...

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.

Instructions

  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

Related Video

Author: Dave Dunn

Dave Dunn joined Webucator as Chief Operating Officer in early 2009. He has served as a CFO and COO for numerous small and medium-sized companies, including Summit Software Company, Insight Research Group, Avalon Consulting, CampaignBase.com and HealthcareOne. He has expertise in business development, financial management, marketing and human resources and particularly enjoys working with rapidly growing companies.

Dave received his Bachelor of Arts from Hamilton College and his MBA from Syracuse University. He has served as Chairman of the Board of the Montessori School of Syracuse since 2001.

Discuss