Microsoft Office Tutorials and References
In Depth Information
Copying and pasting
TABLE 8-1 Essential keyboard shortcuts
Copying and pasting
After you copy, you can paste more than once. As long as the marquee is visible, you can
continue to paste the information from the copied cells. You can copy this information to
other worksheets or workbooks without losing your copy area marquee. The marquee
persists until you press Esc or perform any other editing action. The area you select for copying
must be a single rectangular block of cells. If you try to copy nonadjacent ranges, you get
an error message.
Collecting multiple items on the Clipboard
Although you cannot copy nonadjacent selections, you can use the Collect And Copy
feature to copy (or cut) up to 24 separate items and then paste them where you want them—
one at a time or all at once. You do this by displaying the Clipboard task pane shown in
Figure 8-1 by clicking the dialog box launcher next to the word Clipboard on the Home tab
on the ribbon.
Ordinarily when copying, you can work with only one item at a time. If you copy several
items in a row, only the last item you copy is stored on the Clipboard. However, if you first
display the Clipboard task pane and then copy or cut several items in succession, each item
is stored in the task pane, as shown in Figure 8-1.
You can change the regular collect-and-copy behavior so that Excel collects items every
time you copy or cut regardless of whether the Clipboard task pane is present. To do so,
click the Options button at the bottom of the Clipboard task pane (shown in Figure 8-1),
and click Collect Without Showing Office Clipboard or Show Office Clipboard
Automatically, depending on whether you want the task pane to appear. The latter option activates
an additional option, Show Office Clipboard When Ctrl+C Pressed Twice, which is one of
the “automatic” methods.
Search JabSto ::

Custom Search