| | Product Information Help and How-to Training Templates Support and Feedback Technical Resources Additional Resources | Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Copy and paste multiple items by using the Office Clipboard
The Microsoft Office Clipboard allows you to copy up to 24 multiple text and graphical
items from Office documents or other programs and paste them
into another Office document. For example, you can copy text from an e-mail message, data from a workbook or datasheet, and a graphic from a presentation and then paste them all into a document. By using the Office Clipboard, you can arrange the copied items the way that you want in the document.
What do you want to do?
Learn more about how the Office Clipboard works
The Office Clipboard works with the standard
Copy and
Paste commands. Just copy an item to the Office
Clipboard to add it to your collection, and then paste it from the Office Clipboard
into any Office document at any time. Up to 24 collected items stay on the Office
Clipboard until you exit all Office programs or you delete the
items from the Clipboard task pane.

After you exit all Office programs, only the last item that you copied stays on the Office Clipboard. When you exit all Office programs and restart your computer, the Office Clipboard is cleared of all items.
The Office Clipboard and the system
Clipboard
The Office Clipboard is related to the system Clipboard in Microsoft Windows in the
following ways:
- When you copy multiple items to the Office Clipboard, the last
item that you copy is always copied to the system Clipboard.
- When you clear the Office Clipboard, the system Clipboard is also
cleared.
- When you use the
Paste command, the
Paste button, or the keyboard shortcut CTRL+V,
you paste the contents of the system Clipboard, not the Office
Clipboard.
Top of Page
Turn on the Office Clipboard
Which 2007 Microsoft Office system
program are you using?
Access
- On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

Top of Page
Excel
- On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

Top of Page
Outlook
- In an open message, on the Message tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

Top of Page
PowerPoint
- On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

Top of Page
Publisher
- On the Edit menu, click Office Clipboard.
Top of Page
SharePoint Designer
- On the Edit menu, click Office Clipboard.
Top of Page
Word
- On the Home tab, in the Clipboard group, click the Clipboard Dialog Box Launcher.

Top of Page
Control how the Office Clipboard is displayed
You can use the following options to control how the Office Clipboard is displayed.
- In the
Clipboard task pane, click
Options.

- Click the options that you want.
| Option |
Description |
| Show Office Clipboard
Automatically |
Automatically displays the Office Clipboard when copying
items. |
| Show
Office Clipboard When CTRL+C Pressed Twice |
Automatically displays the Office Clipboard when you press CTRL+C twice. |
| Collect Without
Showing Office Clipboard |
Automatically copies items to the Office Clipboard without
displaying the Clipboard task pane. |
| Show Office Clipboard
Icon on Taskbar |
Displays the
Office Clipboard icon
in the status area of the system taskbar when the Office
Clipboard is active. This option is turned on by default. |
| Show Status Near
Taskbar When Copying |
Displays the collected item message when copying items to the
Office Clipboard. This option is turned on by default. |
Top of Page
Turn off the Office Clipboard
Do any of the following:
- In the
Clipboard task pane, click the Close button.

- In the
Clipboard task pane, click the arrow, and then on the menu, click Close.

- Press F6 to give the Clipboard task pane the focus. Press CTRL+SPACEBAR, and then, using the DOWN ARROW key, scroll to Close and press ENTER.
Top of Page
Copy multiple items to the Office Clipboard
Which 2007 Microsoft Office system
program are you using?
Access
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Home tab, in the Clipboard group, click Copy.
Keyboard shortcut To copy an item, press CTRL+C. 
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
Excel
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Home tab, in the Clipboard group, click Copy.
Keyboard shortcut To copy an item, press CTRL+C. 
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
Outlook
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Home tab, in the Clipboard group, click Copy.
Keyboard shortcut To copy an item, press CTRL+C. 
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
PowerPoint
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Home tab, in the Clipboard group, click Copy.
Keyboard shortcut To copy an item, press CTRL+C. 
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
Publisher
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Edit menu, click Copy.
Keyboard shortcut To copy an item, press CTRL+C.
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
SharePoint Designer
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Edit menu, click Copy.
Keyboard shortcut To copy an item, press CTRL+C.
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
Word
- Open the file that you want to copy items from.
- Select the first item that you want to copy.
- On the Home tab, in the Clipboard group, click Copy.
Keyboard shortcut To copy an item, press CTRL+C. 
- Continue copying items from
the same or other files until
you have collected all of the items that you want. The Office Clipboard can hold up to 24 items. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.
If you open the Clipboard task pane in one Office
program, the Clipboard task pane does not automatically appear when you switch to
another Office program. However, you can continue to copy items from other
programs. If the Show Status Near
Taskbar When Copying option is selected (to verify, click Options in the Clipboard task pane), a message is displayed above the status area to indicate that an item has
been added to the Office Clipboard.

As items are added to the Office Clipboard, an entry is displayed
in the Clipboard task pane. The newest entry is always added to the top. Each entry includes an icon representing the source Office program
and a portion of copied text or a thumbnail of a copied graphic. 
Notes
Top of Page
Paste items
You can paste items from the Office Clipboard individually or all
at the same time.
- Click where you want the items to be pasted. You can paste
collected items into any Office program.
- Do one of the following:
- To paste items one at a time, in the Clipboard task pane, double-click
each item that you want to paste.
- To paste all the items that you copied, in the Clipboard task pane, click
Paste All.

Note The Paste Special command is available from the Clipboard group but is not integrated into the Office Clipboard task pane functionality.

Top of Page
Delete items from the Office Clipboard
You can delete items from the Office Clipboard individually or all
at the same time.
In the Clipboard task pane, do one of the following:
- To clear one item, click the arrow next to the item that you want to delete, and then click Delete.

- To clear all items, click Clear All.

Top of Page
|