Microsoft Office Tutorials and References
In Depth Information
Editing and undoing entries
Figure 6-12 You can easily make entries in a range of cells by first selecting the entire range.
Note
To enter the same value in all selected cells at once, type your first entry and then press
Ctrl+Enter.
Editing and undoing entries
You can correct simple errors as you type by pressing Backspace. However, to make
changes to entries you have already locked in, you first need to enter Edit mode. (The
mode indicator at the lower-left corner of the status bar has to change from Ready to Edit.)
To enter Edit mode, do one of the following:
Double-click the cell, and position the insertion point at the location of the error.
Select the cell, and press F2. Use the arrow keys to position the insertion point within
the cell.
To select contiguous characters within a cell, place the insertion point just before or just
after the characters you want to replace, and press Shift+Left Arrow or Shift+Right Arrow
to extend your selection.
Note
If you don’t want to take your hands off the keyboard to move from one end of a cell
entry to the other, press Home or End while in Edit mode. To move through an entry
one “word” at a time, press Ctrl+Left Arrow or Ctrl+Right Arrow.
If you need to erase the entire contents of the active cell, press Delete, or press Backspace
and then Enter. If you press Backspace accidentally, click the Cancel button or press Esc to
restore the contents of the cell before pressing Enter. You can also erase the entire contents
Search JabSto ::




Custom Search