If you create a table from your database, 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.

Creating 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 Insert ribbon and click on the Tables button at the left. The following window is displayed:
  4. Ensure that your data range is properly indicated in the first cell. If your table includes headers (as it should) select My table has headers, then choose OK.

  5. A default table format is applied to your data as well as column filters. Also notice a special Tables Format ribbon is displayed. Refer to the heading below for more information on each area of the table.



External Table Data:

Table Style Options

Selecting or deselecting these options affect how the table is formatted, based on the selected Table Styles.

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