Microsoft Office Tutorials and References
In Depth Information
Entering Text: Trespassing Allowed
Figure 2 16. Click the check to place the value in its cell.
Here’s the simplest-case scenario. Type 48 in cell A3 and then press Enter. You’ve just done two
1) installed the number 48 in A3, and
2) moved down a row into cell A4.
Remember you need to execute two steps in order to enter data: Type the value, and then finalize
the entry with some navigational move (including Ctrl-Enter, which actually leaves you in the cell), or by
clicking the check mark.
But if you have second thoughts about entering that value, you need only press the Esc key before
you install it in the cell, or click the X you see above alongside the check mark. Do either of these things
and the value simply won’t make its way in the cell. Note also you’ll only see the X and the check mark
on screen when you start to type in a cell.
(Note that for our purposes, we’ll always tell you to press Enter in order to enter data in their cells
simply as a matter of explanatory convenience. But remember that you can use the other options, too,
unless I state otherwise.)
It’s rather easy, and it should be—so don’t wait for the other shoe to drop. There are no hidden
complexities here. Still, a number of classic data entry features and issues need to be explained, just the
Entering Text: Trespassing Allowed
For one thing, note that when you enter a number it’s pushed by default to the cell’s right border, or
aligned right, as they say in the trade. That’s because our number system is Arabic, and proceeds from
right to left. Enter text, however—and text are data , too—and the results align left, as per our left-to-
right, Roman alphabet.
Now if I type something a bit more extensive—say, the phrase “Microsoft Excel”—in A3, the result
looks like Figure 2–17:
Search JabSto ::

Custom Search