O'Reilly logo

Office 2007 Bible by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh, Cary N. Prague, Faithe Wempen, Herb Tyson, John Walkenbach

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

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

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