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.
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:
- Select the range of cells you want included in the table. The cells can be empty or can contain data.
- Click Insert > Table.
Keyboard shortcut You can also press Ctrl+T or Ctrl+L.
- If the top row of the selected range contains data you want to use as table headers, check the My table has headers box.
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
- Select the range of cells you want included in the table.
- On the Home tab, click Styles > Format as Table.
When you use Format as Table, Excel automatically inserts a table.
- 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.
- 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 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.
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