Microsoft Office Tutorials and References
In Depth Information
Controlling the Office Clipboard
Controlling the Office Clipboard
You’re undoubtedly familiar with the Windows Clipboard. When you copy (or cut) something
(such as text or an image), the information is stored on the Clipboard. Then you can paste the
information somewhere else.
In Office 2000, Microsoft introduced the Office Clipboard. Why another Clipboard? The simple
answer is because the Office Clipboard is more versatile than the Windows Clipboard. It enables
you to store as many as 24 copied items. The Windows Clipboard, on the other hand, can hold
only a single item. When you copy or cut something, the previous Windows Clipboard contents
are wiped out. The downside to the Office Clipboard is that it works only in Microsoft Office
applications (Word, Excel, PowerPoint, Access, and Outlook).
If the Office Clipboard doesn’t seem to be working, you can display it by clicking the dialog box
launcher in the Home
Clipboard group. The dialog box launcher is the smaller icon to the right
of the Clipboard group name. Clicking this dialog box launcher toggles the display of the Office
Clipboard.
Every time you copy (or cut) something, the Office Clipboard displays a portion of the
information (see Figure 44-1). After you stored 24 items, newly added items replace older items. To
paste the information, just select the paste location and click the item in the Office Clipboard.
For Excel users, the Office Clipboard has a serious limitation that makes it almost
worthless: It cannot hold formulas! If you copy a range of formulas to the Office
Clipboard and then paste the data elsewhere, you find that the formula results (not
the formulas themselves) are pasted. In a few situations, this behavior can be
advantageous. In the vast majority of cases, you want to copy and paste formulas, not their
values.
Although the Office Clipboard can be useful, a significant number of users find it annoying. To
control some aspects of the Office Clipboard, click the Options button at the bottom of the
Clipboard task pane (see Figure 44-2). Normally, the Office Clipboard is displayed automatically
whenever you copy two pieces of information. To prevent this from happening, deselect the
Show Office Clipboard Automatically check box.
 
Search JabSto ::




Custom Search