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
- 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 Home ribbon and click on
the Format as Table button at the left. The following window is displayed:
- Select a format from the samples shown.
- Confirm the range of your table and whether your table has headers at the top of the columns (which it should),then choose OK.
- Notice a special Design ribbon is displayed. Refer to the headings
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. 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.
Click on the scroll bar within the Table Styles area to select and apply
a new formatting style to your table.