Using the Office Clipboard in Excel 2007

by rhyttinen on September 2, 2009

The Office Clipboard allows you to assemble data from several locations in the same document or from different Office documents, and then paste the items one at a time into any Microsoft Office document. Unlike the Windows clipboard which holds only one item, the Office Clipboard can store up to 24 items that you have cut or copied.

To use the Office Clipboard feature, ensure that the Clipboard Task Pane is visible by clicking the Clipboard Dialog Launcher on the bottom right corner of the Clipboard command group. Then, use the standard copy or cut commands. Each item, up to 24, that you copy or cut will be individually placed in the Clipboard for your later use.

Once you exit Excel, all items from the Office Clipboard are removed.

To Use the Office Clipboard

  1. On the Home tab in the Clipboard command group, click the Clipboard Dialog Box Launcher.
    Clipboard Dialog Launcher
  2. Select the item you wish to copy or cut.
  3. Click the Copy or Cut button.
  4. Repeat steps two and three for any additional items you want to place on the clipboard.
  5. Set the insertion point in the document where you wish to paste one of the items from the Office Clipboard.
  6. Click the item in the Clipboard list that you want to paste or click Paste All to paste all of the Clipboard items at once.
  7. When finished, click Clear All to remove all items from the Office Clipboard.
  8. To turn off the Office Clipboard, click the Close button on the Clipboard task pane.

This tip also works with Word and PowerPoint documents.

Microsoft Office Clipboard

Similar Posts:

Share and Enjoy:
  • del.icio.us
  • Digg
  • TwitThis
  • Reddit
  • Technorati
  • Facebook
  • StumbleUpon
  • Google Bookmarks
  • Propeller
  • email

Leave a Comment

Previous post:

Next post: