Microsoft Office Tutorials and References
In Depth Information
Selecting a Cell
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Enter Row Titles
The next step in developing the worksheet for this project is to enter the row titles in column A. For
the Personal Budget Worksheet data, the list of income types and expense types make up the row titles. It is
likely that in the future, Bob Gleamin may add more income or expense items. Each income or expense item,
therefore, should be placed in its own row. The row titles in column A for income (Wages, Dividends, and Total),
expenses (Rent, Food, Tuition, Books, Entertainment, Car Payment, Gas, Miscellaneous, and Total), and net
income (Net) identify the numbers in each row.
This process for entering row titles is similar to the process for entering column titles. The following steps
enter the row titles in the worksheet.
• Tap or click cell A4
to select it.
• Type Wages and
then tap cell A5
or press the DOWN
ARROW key to
enter a row title
(Figure 1– 12).
row title, Wages,
entered in cell A4
Figure 1– 12
• Repeat Step 1 to
enter the remaining
row titles in column
A; that is, enter
cell A5, Total in
cell A6, Rent
in cell A9, Food in
cell A10, Tuition
in cell A11,
in cell A12,
in cell A13, Car
cell A14, Gas
in cell A15,
cell A16, Total in
cell A17, and Net
in cell A19 (Figure 1– 13).
Figure 1– 13
Why is the text left-aligned in the cells?
When you enter text, Excel automatically left-aligns the text in the cell. Excel treats any
combination of numbers, spaces, and nonnumeric characters as text. For example, Excel
recognizes the following entries as text: 401AX21, 921–231, 619 321, 883XTY
You can change the text alignment in a cell by realigning it. Other alignment techniques
are discussed later in this chapter.