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

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out