Microsoft Office Tutorials and References
In Depth Information
Moving data isn’t much different from
copying and pasting it. Select the range,
but this time click Home Cut (see Figure
3–15). The keyboard equivalent for cut is
Figure 3–15. The Cut button
Note that, curiously, clicking Cut doesn’t cause the range to disappear from the screen
immediately; the data stays there until you click in the first cell in the destination range
and then click Paste (or press Ctrl+V). Only then does it get uprooted from its original
position and move to its new range.
NOTE: Deleting data is not an equivalent to cutting it. When you press the Delete key, the data
you’ve erased cannot be pasted elsewhere on the worksheet—it’s gone. Pasting is possible only
when you cut the data first.
The Clipboard: The Storage Area for Copied and Cut
By now, you may have taken note of the
button image characterizing the Paste
command: a clipboard, in the Clipboard
button group (see Figure 3–16).
Figure 3–16. The Paste button
The image alludes to an area in Excel’s brain, naturally enough called the Clipboard, in
which data that you’ve copied and/or cut is stored until you decide to paste it. The
Clipboard can warehouse up to 24 different copied or cut items, all of which can be
pasted to your worksheet when you wish. To see what I mean, let’s try it out.
On a blank worksheet, type the text shown in Figure 3–17 (i.e., the text
in cells C9:C12 and the values in cell I11:I13.