Use Office Clipboard to Control Selective Copying

BY STANLEY ZAROWIN

I can copy a word or a group of contiguous words and paste it in another location in a document. But is there a way to copy a bunch of words in different parts of the document and then selectively paste them in different places?

Say hello to the Office Clipboard . It’s one of the most underused tools in Microsoft Office because its default mode is to stay hidden unless you purposely summon it to appear. What’s neat about the Office Clipboard is that all words, numbers or images you copy or cut can be pasted into any Office Suite program—including Word, Excel, Access and Outlook. Let’s take a close look at this versatile Clipboard .

If you click on Edit , Office Clipboard in any of those programs, this panel will appear on the right side of your screen:

You can control how Clipboard works by clicking on the Options button on the bottom of the panel and placing a check next to the variable you want to activate (see screenshot).

If Clipboard is showing when you copy (Ctrl+C) or cut (Ctrl+X) material, that material will appear in the Clipboard panel. You can copy anything in the panel (whether it was copied or cut) by placing your cursor where you want the copy to go and then clicking on the target material in the panel. You can do this as many times as you wish.

SPONSORED REPORT

Building client loyalty with payroll services

In this report, CPA experts detail their tactics for performing successful payroll services, how to mitigate risk in the process, and the impact payroll can have as a value-added service.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.