Create an Excel table in a worksheet

When you create a table in an Excel worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.), it's not only easier for you to manage and analyze its data, but you also get built-in filtering, sorting, and row shading.

Data in an Excel table

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).

To create a table by using the default table style, do this:

  1. Select the range of cells you want included in the table. The cells can be empty or can contain data.
  2. Click Insert > Table.

Tables group on the Insert tab

Keyboard shortcut  You can also press Ctrl+T or Ctrl+L.

  1. If the top row of the selected range contains data you want to use as table headers, check the My table has headers box.

Create Table

If you don’t check the My table has headers box, table headers with default names like Column1 and Column2 are added to your table above its data. You can change default header names at any time.

Create a table in the style you want

  1. Select the range of cells you want included in the table.
  2. On the Home tab, click Styles > Format as Table.

Styles group on the Home tab

When you use Format as Table, Excel automatically inserts a table.

  1. Under Light, Medium, or Dark, click the table style you want to use. If the selected range contains data you want to use as table headers, click a table style that includes a header row.

You can create your own table style to use in the current workbook. After you create a custom table style, it's available for the current workbook when you use Format as Table, under Custom.

Next steps

  • After you create a table, the Table Tools become available, and you'll see a Design tab. You can use the tools on the Design tab to customize or edit the table. Note that the Design tab is visible only when at least one or more cells in the table are selected.
  • After you create a table, you'll see the Quick Analysis button Quick Analysis next to it. Click this button to see tools that can help you analyze your table data, such as conditional formatting, sparklines, charts, or formulas.
  • To add a row, select the last cell in the last row of the table, and press Tab.

In the example shown here, pressing Tab with cell C4 selected expands the table to a fifth row, and moves the selection to the first column in the new row, cell A5.

Select last cell and press Tab to add a new table row

More about tables

Filter data in an Excel table

Use structured references in Excel table formulas

Convert a table to a range

Delete an Excel table in a worksheet

 
 
Applies to:
Excel 2013