O'Reilly logo

Master Visually®: Excel® 2007 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required