Master VISUALLY® Excel® 2010

Chapter 21. 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 to the next cell to the right and to the next ...