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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

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: Economy and health care changes top CPAs’ list

CPA decision-makers’ economic outlook and the House Republicans’ proposed tax changes as part of replacing the Patient Protection and Affordable Care Act received attention recently. See how much you know with this short quiz.