Microsoft Office Tutorials and References
In Depth Information
External Database Connections
● Last Column Click to apply special formatting to the last column in the table. This
option is especially useful if the last column contains totals for each row.
● Banded Rows Apply different background colors for alternating rows to make
reading across a wide table easier.
● Banded Columns Apply different background colors for alternating columns.
In effect, these check boxes allow you to provide very specific customizations to the
current table style. When you combine those options with the 60 entries in the built-in Table
Styles gallery, each of whose color palette and font can in turn be reset using any of 40
built-in themes, you have literally thousands of possible looks to choose from. That’s not
enough? Then build your own table style by clicking the New Table Style link at the bottom
of the Table Styles gallery. Doing so brings up the New Table Quick Style dialog box, where
you can set the properties for each part of the table individually.
Starting from scratch to create a custom table style is difficult and potentially confusing.
In our experience, you’ll find it much simpler to duplicate an existing table style and then
modify the style you copied. In the Table Styles gallery, right-click the style you want to use
as your starting point, and then click Duplicate. That opens the Modify Table Quick Style
dialog box shown here.
In the Name box, replace the default name with a descriptive name. Then select individual
table elements from the list in the center of the dialog box and adjust their definition as
needed. Click the Format button to change font style (bold, italic, and so on), cell borders,
and shading. The four stripe options allow you to set how many rows are in each stripe that
makes up a band. The default is 1, which means that shading alternates from one row to