Creating a Table in Excel

Overview

You can turn a sheet of data into a table for presentation. Excel offers several table styles and formats from which to choose.

In this article, you will learn how to create and format a table in an Excel workbook.

1. Step 1

Excel Spreadsheet displayed with the Format as Table button hgihlighted

First open the Excel file you wish to create a table in.

From the Home tab, click the Format as Table button.

2. Step 2

The table layout popup menu is displayed. Choose the layout and style for your table.

Note: Once you select a table layout, the entire data set will be included in the table.

Example shown here: click the White, Table Style Light 8 option highlighted.

3. Step 3

The Format As Table popup menu is displayed.

You can indicate whether your table has headers and specify the location of data. You select data by clicking and dragging over the desired cells in the worksheet or by typing the appropriate information in the Where is the data for your table? field.

Note: In this example, the dotted green box surrounding the perimeter of the worksheet indicates the entire data set will be included in the table.