How to Copy & Paste Multiple Items

By Ally Laconi

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.

Step 1

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

Step 2

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

Step 3

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 4

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


Step 1

Click where you want to paste your items.

Step 2

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

Step 3

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.

Tips & Warnings

  • 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.