Master Visually®: Excel® 2007

Chapter 23. Working with Tables

Create a Table

You can create a table from any rectangular range of related data in a worksheet. Each row in a table contains information about a single entity or event, and each column contains a specific piece of information. The first row can, but does not need to, contain labels that describe each column's information.

When you create a table, Excel identifies the information in the range as a table and simultaneously formats the table and adds AutoFilter arrows to each column. You can also easily add a summary row to a table that summarizes data in some way. When you press the Tab key with the cell pointer in a table, the cell pointer stays in the table, moving right to the next cell and to the next table row ...