Microsoft Office Tutorials and References
In Depth Information
Formatting the Template
2 Select the range A1:A2. Click the Home tab on the Ribbon and apply the Title cell style to
the range. Select cell A1. Click the Font Size box arrow on the Ribbon and then click 28 in
the Font Size list. Select the range A1:G1. Click the Merge & Center button on the Ribbon.
3 Select cell A2, click the Font Size box arrow on the Ribbon, and then click 22 in the Font
Size list. Select the range A2:G2. Click the Merge & Center button on the Ribbon.
4 Select the range A1:A2, click the Fill Color button arrow on the Ribbon, and then click
Light Blue (column 7, row 7) on the Fill Color palette.
5 Click the Font Color button arrow on the Ribbon and then click White, Background 1
(column 1, row 1) on the Font Color palette.
6 Click the Borders button arrow on the Ribbon and then click Thick Box Border in the
Borders gallery.
7 Select cell A14 to deselect the range A1:A2.
To Format the Column Titles and Total Row
The next steps center and underline the column titles and draw a top and double
bottom border on the Total row in row 12.
1 Select the range A4:G4, click the Center button on the Ribbon, and then apply the
Heading 3 cell style to the range.
2 Select the range A12:G12, assign the Total cell style to the range, and then select cell A14
(Figure 6–18).
Font Size box
arrow
Borders button
arrow
Cell Styles button
Merge & Center
button
Center button
title area with light
blue background,
Title cell style, and
thick box border
centered
column titles
with Heading 3
cell style
total row with
Total cell style
Figure 6–18
 
 
Search JabSto ::




Custom Search