"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

The Secret Of Pasting Multiple Items In One Step


Say you have several lists of data and you want combine them into one list. Maybe they are on different worksheets or even in different workbooks. You have a couple of options. You can copy and paste each list individually, typically what most Excel uses do, or you can copy everything first and then paste them all in one step.

I'll use an example to explain this. Say you have a workbook with separate sheets for each soccer team and each sheet contains the names of soccer players. You want to create a summary worksheet with all of the names together for tracking stats.

You can go to the first team sheet, copy the names, switch to the summary sheet and paste, go to the next team sheet, copy the names and so on. Another option which you may not be aware of is that Office allows you to copy multiple items of data from various worksheets (or even other Office documents) and then paste them in other documents. You can paste them in any order or paste them all in one step. The big secret here is that you need to use the Office Clipboard, which you may or may not have seen. The copy and paste buttons for the Clipboard are on the Clipboard Toolbar. Normally when you copy two items in a row, the Clipboard toolbar will appear automatically. However, if it doesn't appear, you can right click on any toolbar and select Clipboard from the list of available toolbars.

In this simplified example, you can copy the names from the first sheet, copy the names from the next sheet, and when you have the names from all sheets copied (maximum allowed is 12), you can then switch to your summary sheet and paste them all in one step.

Just try it and see how it works!

The Clipboard also gives you the option of pasting the individual items in any order.

When you have multiple items on the clipboard, it may be difficult to remember which item is which. A little trick I've learned is to pause your cursor over the clipboard item for a second and you'll see a small Tool Tip pop up showing a small part of that item. Click on the individual item and it will be pasted.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.