10. Working with Tables

Table Basics

Microsoft Excel’s table feature (formerly known as its list or database feature) and related functions help make it a flexible tool for organizing, maintaining, and reporting data. With Excel, you can easily filter data, sort records, and generate subtotals for a table, all without affecting other information in the same worksheet file. You can use Excel’s calculating, formatting, charting, and printing features on your table, too.

In Excel, a table is a range of worksheet cells with unique labels in the first row that has been identified as a table. Figure 1 shows an example of a very small, basic table with header and total rows.

Figure 1. Here’s a tiny table with just a few records and fields. Note the ...

Get Microsoft Office Excel 2007 for Windows: Visual QuickStart Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.