Microsoft Office Tutorials and References
In Depth Information
select and clear check boxes in this group and view the changes immediately. The Header
Row check box actually adds or removes the header row from the table. The Total Row
check box adds a double border at the bottom of the table and adds another row
containing summary formulas. If you add the summary row, you can select which summary
function you want to use by clicking the summary formula in the totals row and then clicking
the menu arrow that appears. The menu offers a selection of functions—including Sum (the
default), Average, Max, and Min—or you can select More Functions to display the Insert
Function dialog box.
Figure 9-7 The Table Tools Design tab appears on the ribbon whenever you select a cell in a
Did your Design tab disappear?
The Table Tools Design tab appears only when you select a cell that is part of a table.
When you select any cell outside the table, this context-triggered tab disappears, and
the Home tab is activated.
The two “Banded” check boxes on the Table Tools Design tab—Banded Rows and Banded
Columns—are useful. In large worksheets, row banding often makes it easier to track long
rows of data across a screen or printed page. In previous versions of Excel, banding required
you to construct an esoteric conditional formatting formula using the MOD function.
Banding is now easier than ever to apply in Excel thanks to these two options, and unlike the