The Power of the Microsoft Office 2007 Clipboard

The clipboard in Microsoft Office 2007 is one of the most under-utilized functions in the entire suite of Office programs. Many of us use the basic copy and paste, but we neglect the other power features of this tool. Today I will cover some of these power features and their uses.

Copy Multiple Items Into Your Clipboard

Much to nearly everyone's surprise, the clipboard can hold more then one clip at a time! To see for yourself, open up your favorite Office 2007 program (Word and Excel work best) and click on the Show Office Clipboard Pane button in the Clipboard grouping. Now, begin copying text from anything you like. I copied some things from Firefox, a favorite browser among the Technology staff here at the Library. You'll notice a small pop-up in the bottom right corner of your screen:

You'll notice that the clipboard says "3 of 24:" I've copied information into 3 of my 24 clipboard available slots. Go back into the Office program you have open, and you'll be able to see the items in your clipboard (right).

You'll notice that each piece of information includes either a mini-thumbnail, for images, or the first few words, for text, in the clipboard. Now, click on an item in the clipboard and it will instantly be pasted into your file.

The Paste Special Command

The paste special command is one of my favorites in MS Office. Frequently when searching the internet I come across text that I want to copy that has multiple types of formatting. When I paste the text into a Word Document I get a jumble of various word formatting that looks terrible.

Here is where the paste special command can help. Click on the drop down arrow under Paste and choose Paste Special. Now choose your selection. In this this example, I would choose unformatted text. Voila! You have clean, unformatted text added to your document.

These are just a few of the main features of this helpful clipboard tool.