How to combine or import multiple Excel workbooks?

E

Edwin

I have several workbooks with different types of statistical data. I want to
combine all the workbooks to a single workbook. Is it possible?
 
E

Edwin

I have more than a dozen of files. I tried moving it individually. Its time
consuming and Excel closes down. Could you tell me some method with fewer
steps?
 
S

ShaneDevenshire

Hi,

1. Open all the files at once or as many as you choose.
2. Choose Window, Arrange All, Tile
3. To copy the sheet from one workbook to the other hold down the Ctrl key
and drag the sheet tab from the source workbook to the target workbook
3a. To move the sheet from one workbook to another just drag, without the
Ctrl key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Serious Excel Challenge 0
combine multiple workbooks? overcome 255 character limit? 3
How do I merge/combine different workbooks with different sheets 2
How do I combine five Excel 2003 workbooks? 2
Excel Protection 2
How do pull data from more than one excel wookbook to one? 1
consolidate and compare workbooks in excel 1
Two Workbooks into 1 File?? 2

Top