Formatting data as a table

A List in earlier versions of Excel has become a table in “Excel 2007”.

To create a table from the data in the spreadsheet, select the range of data that we want in our table, and click “Format as Table” in the “Ribbon”.
Choose the “Insert” tab in the “Ribbon” and click the button “Format as Table”.
This opens a window with a whole bunch of different formats for tables.
The command “Format as Table” has also the Live Preview option, so we can first see how it looks, before we apply this formatting.
If you find your choice, click the example from the list.

This displays the ‘Format as table” dialog.

In this dialog, we determine the range that we want to include in our table.
As the range already was selected, this field will automaticaly be filled in.

The dialog also has a “My Table has Headers” checkbox.
If you want headers in your table then check this box else uncheck it.

Click OK.

Our data is stored in a table.
You see an extra tab at the top of the “Ribbon”, divided into four sections where we can set different options for our table.

Let me take you though this.
At the top left in the “Ribbon”we can name a table.
We find the “Resize Table”, where we can change our table range.
To its right we have the “Summarize with PivotTable”, which creates a PivotTable.
We also find the “Remove Duplicates” button, which removes duplicate records from our table.
Below that we have the “Convert to Range” button, which converts a table to a range and retains the formatting.
The third section contains buttons to export our table to a server, this is beyond the scope of this lesson.
And in the fourth section we have the “Header Row”, “Total Row”, “Banded rows”, “First column”, “Last Column” and “Banded columns” buttons.
These options I think are clear.

By default, a table will have an AutoFilter at the top of each row.
We will see more about the AutoFilter in the next lesson.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats