Office 2007: Sharing Data with the Office Clipboard


Cutting, copying, and pasting data may be handy within the same file, but Office 2007 also gives you the ability to cut, copy, and paste data between different programs, such as copying a chart from Excel and pasting it into a PowerPoint presentation.

Using the Office Clipboard
When you cut or copy any data, Windows stores it in a special part of memory called the Clipboard. This Windows Clipboard can only hold one item at a time, so Office 2007 comes with its own Clipboard called the Office Clipboard, which can store up to 24 items.

Whereas the Windows Clipboard works with any Windows program (such as Microsoft Paint or WordPerfect), the Office Clipboard works only with Office 2007 programs (such as Word, Excel, PowerPoint, Access, and Outlook). To store data on the Office Clipboard, you just need to use the Cut or Copy command, and Office 2007 automatically stores your data on the Office Clipboard.

The two big advantages of the Office Clipboard are

You can store up to 24 items.
The Windows Clipboard can store only one item.
You can select what you want to paste from the Clipboard.
The Windows Clipboard lets you paste only the last item cut or copied.
Viewing and pasting items off the Office Clipboard
After you use the Cut or Copy command at least once, your data gets stored on the Office Clipboard. You can then view the Office Clipboard and choose which data you want to paste from the Clipboard into your file.

To view the Office Clipboard and paste items from it, follow these steps:

1. Move the cursor to the spot where you want to paste an item from the Office Clipboard.

2. Click the Office Clipboard icon.

The Office Clipboard pane appears. The Office Clipboard also displays an icon that shows you the program where the data came from, such as Word or PowerPoint.

3. Click the item you want to paste.

Office 2007 pastes your chosen item into the file where you moved the cursor in Step 1.

4. Click the Close box of the Office Clipboard window to tuck it out of sight.

If you click the Paste All button, you can paste every item on the Office Clipboard into your file.


Deleting items from the Office Clipboard
You can add up to 24 items to the Office Clipboard. The moment you add a 25th item, Office 2007 deletes the oldest item from the Office Clipboard to make room for the new cut or copied item.

You can also manually delete items from the Office Clipboard as well, by following these steps:

1. Click the Office Clipboard icon.

The Office Clipboard appears.

2. Move the mouse pointer over an item on the Office Clipboard.

A downward-pointing arrow appears to the right. A pop-up menu appears.

3. Click Delete.

Office 2007 deletes your chosen item.

4. Click the Close box to tuck the Office Clipboard out of sight.

If you click the Clear All button, you can delete every item currently stored on the Office Clipboard.

Make sure you really want to delete an item from the Office Clipboard because after you delete it, you can't retrieve it (and neither can Fido).