Create and format tables

Applies to: Excel for Office 365, Excel for Office 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011.

You can create and format a table, to visually group and analyse data.

Note: Excel tables shouldn’t be confused with the data tables that are part of a suite of What-If Analysis commands (Data Tools, on the Data tab). See Introduction to What-If Analysis for more information.


  1. Firstly, add a table in your spreadsheet. See Overview of Excel tables for more information.
  1. Secondly, choose a cell within your data.
  1. Thirdly, pick Home Format as Table.
  1. Fourthly, select a style for your table.
  1. Next, define your cell range. Do this in the Format as Table dialogue box.
  1. After this, highlight if your table has headers.
  1. Finally, press OK.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Overview of Excel tables

Video: Create and format an Excel table

Total the data in an Excel table

Format an Excel table

Resize a table by adding or removing rows and columns

Filter data in a range or table

Convert a table to a range

Using structured references with Excel tables

Excel table compatibility issues

Export an Excel table to SharePoint

Leave a Reply

%d bloggers like this: