Turbocharge Your Clipboard to Copy & Paste Multiple Items

Ever wish Excel could remember the last 10 things you copied to the clipboard, and would let you paste any of them?  In fact, you can get it to remember the last 24, when you activate the Office Clipboard.

Suppose you’re working with a long list of company names that you need to copy and paste repeatedly:

W-Clipboard-entitylistt

Activate the Office Clipboard by clicking the button on the lower right-hand corner of the Clipboard group on the Home tab:

W-Clipboard-button

This opens up the Office Clipboard – the default view is a narrow window on the left side of the screen.  Every time you copy a cell, part of a cell, a picture, or anything else, it is listed in this window, from most to least recent:

W-Clipboard-1stcopy

Beautiful Enterprise is now clipboard item 1 of 24 . . .

W-Clipboard-2ndcopy

. . . and Cisco Linksys Kiss is now item 2 of 24.

Paste any item from the clipboard by clicking on it, or selecting Paste from the dropdown attached to that item on the clipboard:

W-Clipboard-options

Once you hit 24 items, Office will start to recycle the clipboard entries starting with the oldest ones.  You can delete items you no longer need to make room for new ones.  There is a counter in the lower right-hand corner of the screen that keeps track of how many items you’ve pasted:

W-Clipboard-2of24itemcollected

You can unpin the clipboard from the left side of the screen and move it to a more convenient place on your screen.  Simply click on the header of the clipboard and drag it where you want it.  It will now appear as a standalone window:

W-Clipboard-unpinned

Click the Options button at the bottom of the window to see what else you can do.  For example, you can select Collect without Showing Office Clipboard, and Office will continue to collect multiple items, and tell you how many you have, without displaying the clipboard:

W-Clipboard-collect

The Office clipboard can be used across applications; that means that the multiple items you copied from an Excel spreadsheet can be pasted into a Word document, or vice-versa:

W-Clipboard-pasteintoword

Hope you enjoy this new tip, and feel free to share, link, or repost.    Follow the Excel Esquire blog to get updates, and to learn about CLE-accredited Excel workshops!

Advertisements

About excelesquire

NYC attorney and Excel enthusiast.
This entry was posted in eDiscovery, Everybody, Privilege Logs. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s