Microsoft Office Tutorials and References
In Depth Information
Formatting the Template
Formatting the Template
Summing a Row
or Column
You can reference an
entire column or an entire
row in a function argu-
ment by listing only the
column or only the row.
For example, =sum(a:a)
sums all the values in all
the cells in column A, and
=sum(1:1) sums all the
values in all the cells in
row 1. You can verify this
by entering =sum(a:a) in
cell C1 and then begin
entering numbers in a few
of the cells in column A.
Excel will respond by
showing the sum of the
numbers in cell C1.
The next step is to format the template so it appears as shown in Figure 6–17. The following
list summarizes the steps required to format the template.
1. Format the titles in cells A1 and A2.
2. Format the column titles and add borders to rows 4 and 12.
3. Assign the Currency style format with a fl oating dollar sign to the nonadjacent
ranges C5:G5 and D12:G12.
4. Assign a Custom style format to the range C6:G11.
5. Assign a Comma style format to the range B5:B12.
6. Create a format style and assign it to the date in cell G3.
template fi le name is
displayed on title bar
title area with
light blue
Title cell style,
and thick box
four-digit year
format assigned
using a style
centered column
titles with Heading 3
cell style
Currency style format with
fl oating dollar sign and two
decimal places
Custom format
total row with
Total cell style
Comma style format
with no decimal places
Figure 6–17
To Format the Template Title and Subtitle
To copy the contents
of a cell to the cell
directly below it, click
in the target cell and
press CTRL + D .
The steps used to format the template title and subtitle include changing cell A1 to
28-point with the Title cell style; changing cell A2 to 22-point with the Title cell style;
centering both titles across columns A through G; changing the title background color to
light blue and the title font to white; and drawing a thick box border around the title area.
The color scheme associated with the default Offi ce template also will be changed to a
new color scheme. One reason to change the color scheme is to add variety to the look of
the worksheet that you create. The following steps format the title and subtitle.
1 Click the Page Layout tab on the Ribbon. Click the Colors button on the Ribbon and then
click Apex in the Colors gallery.
Search JabSto ::

Custom Search