Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Importing and Exporting Data
Using the Office clipboard
Using the Windows clipboard works the same way as using the Office
clipboard, except that the Office clipboard has more features; it can store up
to 24 clips compared with one clip for the Windows clipboard, for example.
You can use the Office clipboard when cutting and pasting within Office
applications, and you can use the Windows clipboard for copying and
pasting in any Windows application that supports its use. When you cut or copy
something to the clipboard, that content is saved on both the Windows and
Office clipboards. When you paste from the clipboard by pressing a key or
clicking a button, you get the most recent thing you put on the clipboard,
which is also the top item on the Office clipboard.
If you always get the most-recently-copied item, what’s the point of the
Office clipboard storing up to 24 of your recent clips? The Office clipboard
stores items from all Office applications: Access, Excel, Word, Outlook, and
PowerPoint. If you want to see your clips, click the secret clipboard button
on the Home tab of the Ribbon. (Okay, technically it’s called the clipboard
Dialog Box Launcher, but seriously, what was Microsoft thinking, making
those tiny boxes and calling them buttons?) That button is to the right of the
word Clipboard, below the Paste button, as shown in Figure 4-2.
The clipboard task pane displays the clips that you cut or copy, along with
an icon that shows you what type of clip it is (Access, Excel, Word, and so
on). Paste any clip — not just the most recent one — at the cursor’s position
by clicking the clip in the clipboard pane. Delete a clip from the clipboard by
right-clicking the icon and choosing Delete from the contextual menu. Clicking
the Paste All button pastes all the stored items at the cursor’s position.