Copying and pasting is sometimes the easiest way to assemble a project when you have work or data scattered across different files. When you have to copy and paste a long series of items, though, it becomes a tedious and error-prone task. Using the Clipboard feature, you can copy items from multiple Office applications—Excel, Word, PowerPoint, and so on—and then paste them all simultaneously, rearranging them together into one cohesive document.
Access the file or files from which you want to copy items. Open Word, Excel or PowerPoint, for example.
Video of the Day
Click the Clipboard Dialog Box Launcher—the small arrow located at the corner of the Clipboard group, in the Home tab.
Select the first item you want to copy by highlighting it with your left mouse key. Right-click on the selected item, then click "Copy" on the menu that appears. Alternately, you can use the keyboard shortcut CTRL+C. Copied items will appear on the Clipboard.
Copy all of the items you need from one or more files.
Click where you want to paste your items.
Select "Paste All" from the Clipboard task pane to paste all copied items simultaneously.
Double-click each item individually if you want to paste them one at a time—for example, if you didn't copy them in the same order in which you want to paste them.
The Clipboard can hold up to 24 copied items at a time. If you copy a 25th item, the first item on the Clipboard will be deleted.