Microsoft Office Tutorials and References
In Depth Information
Entering the Titles and Numbers into the Worksheet
Wrapping Text
If you have a long
text entry, such as a
paragraph, you can
instruct Excel to wrap
the text in a cell, rather
than pressing ALT + ENTER
to end a line. To wrap
text, right-click in the
cell, click Format Cells
on the shortcut menu,
click the Alignment tab,
click Wrap text, and
then click OK. Excel will
increase the height of
the cell automatically
so the additional lines
will fi t. If you want to
control where each line
ends in the cell, rather
than letting Excel wrap
based on the cell width,
however, then you
must end each line with
ALT + ENTER .
3 In cell C3, type Date and then press ALT + ENTER . Type Acquired and then press the RIGHT
ARROW key.
4 In cell D3, type Shares and then press the RIGHT ARROW key.
5 In cell E3, type Initial and then press ALT + ENTER . Type Price and then press ALT + ENTER .
Type Per Share and then press the RIGHT ARROW key.
6 Type Initial in cell F3 and then press ALT + ENTER . Type Cost and then press the RIGHT
ARROW key .
7 In cell G3, type Current and then press ALT + ENTER . Type Price and then press ALT + ENTER .
Type Per Share and then press the RIGHT ARROW key.
8 Type Current in cell H3 and then press ALT + ENTER . Type Value and then press the RIGHT
ARROW key .
9 In cell I3, type Gain/Loss and then press the RIGHT ARROW key.
10 In cell J3, type Percent and then press ALT + ENTER . Type Gain/Loss .
To Enter the Portfolio Summary Data
Two-Digit Years
When you enter a
two-digit year value,
Excel changes a two-
digit year less than 30
to 20xx and a two-digit
year of 30 and greater
to 19xx. Use four-digit
years to ensure that Excel
interprets year values
the way you intend, if
necessary.
The portfolio summary data in Table 2–1 includes a purchase date for each stock.
Excel considers a date to be a number and, therefore, it displays the date right-aligned in
the cell. The following steps enter the portfolio summary data shown in Table 2–1.
1 Select cell A4, type Apple Computers , and then press the RIGHT ARROW key.
2 Type AAPL in cell B4 and then press the RIGHT ARROW key.
3 Type 12/1/04 in cell C4 and then press the RIGHT ARROW key.
4 Type 440 in cell D4 and then press the RIGHT ARROW key.
5 Type 64.59 in cell E4 and then click cell G4.
6 Type 82.99 in cell G4 and then click cell A5.
7 Enter the portfolio summary data in Table 2–1 for the eight remaining stocks in rows 5
through 12 (Figure 2–4).
To Enter the Row Titles
Formatting a
Worksheet
With early worksheet
programs, users often
skipped rows to improve
the appearance of the
worksheet. With Excel it
is not necessary to skip
rows because you can
increase row heights to
add white space between
information.
1 Select cell A13. Type Totals and then press the DOWN ARROW key. Type Average in
cell A14 and then press the DOWN ARROW key.
2 Type Highest in cell A15 and then press the DOWN ARROW key. Type Lowest in cell A16
and then press the ENTER key. Select cell F4 (Figure 2–4).
 
 
Search JabSto ::




Custom Search