How to Copy & Paste Multiple Items

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.

...
Save time and avoid repetition-induced errors by using the Clipboard feature.

Step

Access the file or files from which you want to copy items. Open Word, Excel or PowerPoint, for example.

Step

Click the Clipboard Dialog Box Launcher—the small arrow located at the corner of the Clipboard group, in the Home tab.

Step

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.

Step

Copy all of the items you need from one or more files.

Paste

Step

Click where you want to paste your items.

Step

Select "Paste All" from the Clipboard task pane to paste all copied items simultaneously.

Step

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.