Microsoft Office Tutorials and References
In Depth Information
Creating the Template
To Bold the Font and Adjust the Row Heights and Column Widths
of the Template
The ﬁ rst step in creating the template is to change the font style to bold and adjust
the height of row 4 to 30.75 points and column widths of columns A and C through
G to 13.00 characters.
Selecting a Range
You can select any range
of cells with entries
surrounded by blank
cells by clicking a cell in
the range and pressing
CTRL + SHIFT + ASTERISK (*).
1 Click the Select All button immediately above row heading 1 and to the left of column
heading A and then click the Bold button on the Ribbon. Select cell A1 to deselect the
2 Drag the bottom boundary of row heading 4 down until the ScreenTip, Height 30.75
(41 pixels), appears.
3 Drag the right boundary of column heading A to the right until the ScreenTip, Width:
13.00 (96 pixels), appears.
4 Click column heading C, drag through to column heading G, and then drag the right
boundary of column heading G right until the ScreenTip, Width: 13.00 (96 pixels), appears.
Select cell A1 to deselect columns C through G.
To Enter the Title, Subtitle, and Row Titles in the Template
The following steps enter the titles in cells A1 and A2 and the row titles in column A.
1 Type NextDVR, Inc. in cell A1 and then press the DOWN ARROW key.
2 Type Region Proﬁ t Potential in cell A2 and then press the DOWN ARROW key twice to
make cell A4 active.
You can display a future
date, such as tomorrow’s
date, in a cell by adding
a number to the NOW
or TODAY function. For
displays tomorrow’s date
in a cell and =NOW()+14
displays a date two
weeks in the future. The
function =NOW() – 1
displays yesterday’s date.
3 Type Company and then press the DOWN ARROW key.
4 With cell A5 active, enter the remaining row titles in column A as shown in Figure 6–5 on
the next page.
To Enter Column Titles and the System Date in the Template
The next step is to enter the column titles in row 4 and the system date in cell G3.
1 Select cell B4. Type Units and then press ALT + ENTER . Type On Hand and then press the
RIGHT ARROW key.
You can use the DATE
function to change a
year, month, and day
to a serial number that
automatically is format-
ted to mm/dd/yyyy. For
example, if cell A1 equals
the year 2008, cell A2
equals the month 2,
cell A3 equals day 10,
and cell A4 is assigned
the function =DATE (A1,
A2, A3), then 2/10/2008
appears in cell A4. The
DATE function is most
useful in formulas where
year, month, and day are
formulas, not constants.
2 Type Average and then press ALT + ENTER . Type Unit Cost and then press the RIGHT
3 With cell D4 active, enter the remaining column titles in row 4 as shown in Figure 6–5.
4 Select cell G3. Type =now() and then press the ENTER key. Right-click cell G3 and then click
Format Cells on the shortcut menu. When Excel displays the Format Cells dialog box, click
Date in the Category list and then double-click 3/14/01 13:30 in the Type list. Select cell A14
to deselect cell G3.
Why was the date not formatted as it appears in Figure 6–4?
The format assigned to the system date in cell G3 is temporary. For now, it ensures that
the system date will appear properly, rather than as a series of number signs (#). The
system date will be assigned a permanent format later in this chapter.