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
- Select a cell within your database.
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.
- Display the Insert ribbon and click on
the Tables button at the left. The following window is displayed:
- 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.
- 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.
- Table Name: Enter a name for your table within this field.
- Resize Table: As you add data to your table, the table should grow
automatically; however, if this is not the case or you wish to specify a different
size for your table, select Resize Table and select the new range.
- Summarize with PivotTable: Choose this option to create a PivotTable
from your data.
- Remove Duplicates: Choose this option to remove duplicate data from
your table. You will be prompted to specify the column where duplication exists.
- Convert to Range: Select this option to convert the table to a standard
External Table Data:
- Export: Choose this option to export the table to a SharePoint list
or Visio PivotDiagram.
- Refresh: Choose this option to refresh the table based on new data.
Table Style Options
Selecting or deselecting these options affect how the table is formatted, based
on the selected Table Styles.
Click on the scroll bar within the Table Styles area to select and apply
a new formatting style to your table.