Microsoft Office Tutorials and References
In Depth Information
Overview
To Enter the Section Title, Row Titles, System Date, Document
Properties, and Save the Workbook
Global Formatting
To assign formats
to all the cells in all
the worksheets in a
workbook, click the
Select All button, right-
click a tab, and click
Select All Sheets on the
shortcut menu. Next,
assign the formats. To
deselect the sheets, hold
down the SHIFT key and
click the Sheet1 tab. You
also can select a cell or a
range of cells and then
select all sheets to assign
formats to that cell or
a range of cells on all
sheets in a workbook.
The next step is to enter the Loan Payment Calculator section title, row titles,
system date, document properties, and then save the workbook. To make the worksheet
easier to read, the width of column A will be decreased to 1.57 characters and used as a
separator between the Loan Payment Calculator section and the row headings on the left.
Using a column as a separator between sections on a worksheet is a common technique
employed by spreadsheet specialists. The width of columns B through E will be increased
so the intended values fi t. The height of row 1, which contains the title, will be increased
so it stands out. The worksheet title also will be changed to the Title cell style.
The following steps enter the section title, row titles, system date, document properties,
and then save the workbook.
1 Select cell B1. Enter Loan Payment Calculator as the section title. Select the range B1:E1.
Click the Merge & Center button on the Ribbon.
2 With cell B1 active, click the Cell Styles button on the Ribbon and then select the Title cell
style in the Cell Styles gallery.
3 Position the mouse pointer on the bottom boundary of row heading 1. Drag down
until the ScreenTip indicates Height: 23.25 (31 pixels). Position the mouse pointer
on the bottom boundary of row heading 2. Drag down until the ScreenTip indicates
Height: 30.00 (40 pixels).
4 Select cell B2 and then enter Date as the row title and then press the TAB key.
5 With cell C2 selected, enter =now() to display the system date.
6 Right–click cell C2 and then click Format Cells on the shortcut menu. When Excel displays
the Format Cells dialog box, click the Number tab, click Date in the Category list, scroll
down in the Type list, and then click 14–Mar–2001. Click the OK button.
7 Enter the following row titles:
Concatenation
You can concatenate
text, numbers, or text
and numbers from two
or more cells into a single
cell. The ampersand (&)
is the concatenation
operator. For example,
if cell A1 = AB, cell A2
= CD, cell A3 = 25, and
you assign cell A4 the
formula =A1&A2&A3,
then ABCD25 displays in
cell A4.
Cell
Entry
Cell
Entry
B3
D2
Item
Rate
B4
D3
Price
Years
B5
D4
Down Payment
Monthly Payment
B6
D5
Loan Amount
Total Interest
D6
Total Cost
8 Position the mouse pointer on the right boundary of column heading A and then drag to
the left until the ScreenTip indicates Width: 1.57 (16 pixels).
9 Position the mouse pointer on the right boundary of column heading B and then drag to
the right until the ScreenTip indicates Width: 13.86 (102 pixels).
10 Click column heading C to select it and then drag through column headings D and E.
Position the mouse pointer on the right boundary of column heading C and then drag
until the ScreenTip indicates Width: 16.29 (119 pixels).
11 Double–click the Sheet1 tab and then enter Braden Mortgage as the sheet name. Right–
click the tab and then click Tab Color. Click Light Green (column 5, row 1) in the Standard
Colors area and then select cell D6 (Figure 4–4 on the next page).
 
 
Search JabSto ::




Custom Search