Microsoft Office Tutorials and References
In Depth Information
Entering Text and Data
Entering Text and Data
Data entry in Excel is as easy as it is important. Just select the cell you need, and type
the entry—although that doesn’t quite finish the process. When you type in Word, all you
do, after all, is…type. But data entry in Excel requires an additional, but simple step. You
need to confirm what you’ve entered with an additional command—almost always a
navigational keystroke or mouse click.
Let’s illustrate. The typical way to enter data is to select a cell, type whatever you want,
and press the Enter key—and that’s it.
Figure 2–7. Note the cursor alongside the letter l in the first shot. That indicates that you’re still “in” the cell.
When you press Enter, the cell pointer travels down one row.
Pressing Enter does two things:
1. It ”installs” whatever you’ve typed in the cell
2. It bumps the cell pointer down one row, as Enter normally does—
nothing new there (as you’ll see, there’s an exception to this rule—when
you select a range and then enter data into its cells).
Note : If you’re in the process of entering data in a cell and decide you don’t want to continue,
pressing the ESC key will cancel what you’re doing and leave the original cell contents intact.
That’s the way it works—type your data in the cell, and press Enter—OR an arrow key,
OR PgDn or PgUp, OR click the mouse into another cell. Typing data into a cell and
following it up with say, a tap of the right arrow key, also does two things: it installs the
data, and then in this case delivers the cell pointer one column to the right. Completing
the data entry with a mouse click instead will simply land the cell pointer into the cell in
which you’ve clicked—after the data has been installed in the original cell. I told you it
was easy. The idea is that the pointer moves in the desired direction after carrying out
the data entry.
There’s also another way to carry out the data entry process. Select your cell, type
away, and instead of executing one of the standard navigational moves we’ve described
above click the gray check mark alongside the formula bar:
 
Search JabSto ::




Custom Search