Microsoft Office Tutorials and References
In Depth Information
Doing the Data-Entry Thing
Doing the Data-Entry Thing
Begin by reciting (in unison) the basic rule of worksheet data entry. All
together now:
To enter data in a worksheet, position the cell pointer in the cell where
you want the data and then begin typing the entry.
Before you can position the cell pointer in the cell where you want the entry,
Excel must be in Ready mode (look for Ready as the Program indicator at the
beginning of the Status bar). When you start typing the entry, however, Excel
goes through a mode change from Ready to Enter (and Enter replaces Ready
as the Program indicator). If you’re not in Ready mode, try pressing Esc on
your keyboard.
And if you’re doing data entry on a worksheet on a device that doesn’t have
a physical keyboard, for heaven’s sake, open the virtual keyboard and keep it
open (preferably floating) in the Excel window during the whole time you’re
doing data entry. (See “Tips on using the Touch keyboard” in Chapter 1 for
details on displaying and using the virtual keyboard on a touchscreen device.)
As soon as you begin typing in Enter mode, the characters that you type in a
cell in the worksheet area simultaneously appear on the Formula bar near the
top of the screen. Typing something in the current cell also triggers a change
to the Formula bar because two new buttons, Cancel and Enter, appear
between the Name box drop-down button and the Insert Function button.
As you continue to type, Excel displays your progress on the Formula bar
and in the active cell in the worksheet (see Figure 2-2). However, the
insertion point (the flashing vertical bar that acts as your cursor) appears only at
the end of the characters displayed in the cell.
Figure 2-2:
you type
both in the
current cell
and on the
Formula bar.
Search JabSto ::

Custom Search