Excel 2010 Bible

Part I: Getting Started with Excel

84

Using the Office Clipboard to paste ...........................................................................

Whenever you cut or copy information in an Office program, such as Excel, you can place the data

on both the Windows Clipboard and the Office Clipboard. When you copy information to the

Office Clipboard, you append the information to the Office Clipboard instead of replacing what is

already there. With multiple items stored on the Office Clipboard, you can then paste the items

either individually or as a group.

To use the Office Clipboard, you first need to open it. Use the dialog launcher on the bottom right

of the Home ➪ Clipboard group to toggle the Clipboard task pane on and off.

Tip
To make the Clipboard task pane open automatically, click the Options button near the bottom of the task
pane and choose the Show Office Clipboard Automatically option. n

After you open the Clipboard task pane, select the first cell or range that you want to copy to the

Office Clipboard and copy it by using any of the preceding techniques. Repeat this process, select-

ing the next cell or range that you want to copy. As soon as you copy the information, the Office

Clipboard task pane shows you the number of items that you’ve copied and a brief description (it

will hold up to 24 items). Figure 4.9 shows the Office Clipboard with four copied items.

FIGURE 4.9

Use the Clipboard task pane to copy and paste multiple items.

When you’re ready to paste information, select the cell into which you want to paste information.

To paste an individual item, click it in the Clipboard task pane. To paste all the items that you’ve

copied, click the Paste All button (which is at the top of the Clipboard task pane). The items are

pasted, one after the other. The Paste All button is probably more useful in Word, for situations in

which you copy text from various sources, and then paste it all at once.