Microsoft Office Tutorials and References
In Depth Information
Data Entry: Getting Started
mass procedure if, for example, you wanted to change the color of all the text in your worksheet to say,
green. Once you’re finished, just click anywhere on the sheet, and the blue selection color disappears, as
in Figure 2–15:
Figure 2–15. Click here to select all the worksheet cells
A last introductory point about ranges. Like amoeba, ranges can be single-celled, and if you’re at a
loss to understand why—after all, how in the world is selecting a one-celled range different from simply
referring to a single cell?—stay tuned. There are sometimes very good and productive reasons for
working this way. (Note: See the appendix on range names for a discussion of this and other
rangerelated tips.)
Data Entry: Getting Started
But now that we’ve learned how to get where we want to go on the worksheet, let’s learn the things we
can do once we arrive. There are a few billion cells out there craving our attention, and we want to fill at
least some of them with data. Here’s how.
Unlike typing in Microsoft Word, data entry in Excel is a two-step, but still elementary, affair. Type
the number 48 in Word, for example, and you’re done. But enter 48 in a worksheet cell and you need to
complete the process by installing the value in the cell. And that second step is carried out either by any
navigational move away from the cell (e.g., pressing Enter or Page Down, or clicking a different cell) in
which you’ve just typed, or by entering the value and then clicking the check box alongside the formula
bar, as shown in Figure 2–16:
Search JabSto ::

Custom Search