Quick start: Create an Excel table

To make working with data easier, you can organize data in a table format on a 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.).

Data in an Excel table

Tables provide easy filtering, in addition to calculated columns and total rows, which make calculations simple.

Watch the video

How?

Icon image

On a worksheet, select the range of cells that you want to include in the table. The cells can be empty or can contain data.

Icon image

On the Home tab, in the Styles group, click Format as Table, and then click the table style that you want.

Styles group on the Home tab

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

Icon image

If the selected range contains data that you want to display as table headers, select the My table has headers check box in the Format as Table dialog box.

Table headers display default names if you do not select the My table has headers check box. You can change the default names by selecting the default header that you want to replace, and then typing the text that you want

Next steps

  • The Table Tools become available when you select a table, and a Design tab is displayed. To get a good idea of what you can add to or change in your table, click the Design tab, and then explore the groups and options that are provided on this tab.
  • For detailed instructions on how to create a table, see Create or delete an Excel table in a worksheet.

Top of Page Top of Page

 
 
Applies to:
Excel 2010