Format as Table

Microsoft Excel 2010

If you format your data as a table you can easily apply table style formatting and access a variety of other table tools such as removing duplicate entries and adding a total row. This feature replaces the old Data Lists feature in earlier versions of Excel.

Format as A Table

  1. Select a cell within your database.
  2. You do not need to select your data range first if your data is presented in a proper list, i.e. no blank rows or columns and you have used column/row headers.

  3. Display the Home ribbon and click on the Format as Table button at the left. The following window is displayed:
  4. Select a format from the samples shown.
  5. Confirm the range of your table and whether your table has headers at the top of the columns (which it should),then choose OK.
  6. Notice a special Design ribbon is displayed. Refer to the headings below for more information on each area of the table.

Properties

Tools

External Table Data:

Table Style Options

Selecting or deselecting these options affect how the table is formatted, based on the selected Table Styles. To easily summarize your data, select Total Row then click on the new row at the bottom of your table to click in simple functions such as Sum, Average, etc.

Table Styles

Click on the scroll bar within the Table Styles area to select and apply a new formatting style to your table.

Additional References