Office 2007 Bible

Using Formulas in Tables

One of the most significant new features in Excel 2007 is its support for tables. In this section I describe how formulas work with tables.

Summarizing data in a table

Figure 15-10 shows a simple table with three columns. I entered the data, and then converted the range to a table by choosing Insert Tables Table. Note that I didn’t define any names, but the table is named Table1 by default.

Figure 15-10. A simple table with three columns.

If you’d like to calculate the total projected and total actual sales, you don’t even need to write a formula. Simply click a button to add a row of summary formulas to the table:

1.	Activate any cell in the table.
2.	Place a check mark next to Table Tools Design Table Style Options Total Row.
3.	Activate a cell in the Total Row and use the drop-down list to select the type of summary formula to use (see Figure 15-11). ...