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

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.