Microsoft Office Tutorials and References
In Depth Information
Fixing Those Data Entry Flub-Ups
Doing either one reactivates the Formula bar by displaying the Enter
and Cancel buttons once again and placing the insertion point in the cell
entry in the worksheet. (If you double-click or double-tap, the insertion
point positions itself wherever you click; press F2, and the insertion
point positions itself after the last character in the entry.)
Notice also that the mode indicator changes to Edit. While in this mode,
you can use the mouse or the arrow keys to position the insertion point
at the place in the cell entry that needs fixing.
In Table 2-2, I list the keystrokes that you can use to reposition the insertion
point in the cell entry and delete unwanted characters. If you want to insert
new characters at the insertion point, simply start typing. If you want to delete
existing characters at the insertion point while you type new ones, press the
Insert key on your keyboard to switch from the normal insert mode to
overtype mode. To return to normal insert mode, press Insert a second time. When
you finish making corrections to the cell entry, you must complete the edits by
pressing Enter before Excel updates the contents of the cell.
While Excel is in Edit mode, you must re-enter the edited cell contents by
either clicking the Enter button or pressing Enter. You can use the arrow keys
as a way to complete an entry only when the program is in Enter mode. When
the program is in Edit mode, the arrow keys move the insertion point only
through the entry that you’re editing, not to a new cell.
Table 2-2
Keystrokes for Fixing Those Cell Entry Flub-Ups
Keystroke
What the Keystroke Does
Delete
Deletes the character to the right of the insertion point
Backspace
Deletes the character to the left of the insertion point
Positions the insertion point one character to the right
Positions the insertion point one character to the left
Positions the insertion point, when it is at the end of the cell entry,
to its preceding position to the left
End or
Moves the insertion point after the last character in the cell entry
Home
Moves the insertion point in front of the first character of the
cell entry
Ctrl+
Positions the insertion point in front of the next word in the cell entry
Ctrl+
Positions the insertion point in front of the preceding word in the
cell entry
Insert
Switches between insert and overtype mode
Search JabSto ::




Custom Search