Datasheet

Copy with the

Office Clipboard

ith Office 2007, you can place content into a

storage area called the Clipboard and then

paste the content into Excel or another Office

application. Cut and copied content stays on the Clipboard

until you close all Office applications. The Office Clipboard

can store up to 24 cut or copied items. When you add the

25th item, Office deletes the first item. You can store text

and graphics on the Clipboard. As you add items to the

Clipboard, they appear at the top of the Clipboard task pane.

All the items on the Clipboard are available for you to paste

to a new location in Excel or into another Office document.

The Clipboard is not visible until you access it. In Excel,

you access the Clipboard by clicking the launcher in the

Clipboard group of the Home tab. Each item on the

Clipboard appears with an icon that tells you the Office

application the information originated from and shows a

portion of the text or a thumbnail if the item is a graphic.

You can also use the Clipboard to store a range of cells.

The Office Clipboard pastes the entire range, including all

the values, but any formulas in the cells are not included

when you paste. You can paste everything on your

Clipboard into your worksheet by clicking the Paste

All button. You can clear the Clipboard by clicking the

Clear All button.

After you paste an item from the Clipboard, Excel provides

the Paste Options icon menu. You can use the menu to

choose whether you want to use the source formatting or

the destination formatting for the pasted data.

1 Click and drag to select the cells you want to copy.

2 Click the Home tab.

3 Click the Copy button in the Clipboard group.

Excel places a copy of the information on the

Office Clipboard.

Copy with the Office Clipboard

4 Click the launcher in the Clipboard group.

•

The Clipboard task pane appears.

04_132296 ch01.qxp 5/24/07 12:53 PM Page 18