I want to merge two separate Excel files, each with several worksheets. Can I select the Worksheets (at the bottom of the page) and copy and paste them? Or do I have to create new worksheets and copy and paste the contents?
2006-07-17 07:25:19 · 4 answers · asked by Anonymous in Computers & Internet ➔ Software
If I'm reading this correctly... Then this is how you would do it.
If you have two files... For this excercise, we'll call them Workbook1.xls and it contains 3 sheets (Sheet1, Sheet2, Sheet3) and Workbook2.xls (Sheet4, Sheet5, Sheet6).
Now, to merge the sheets on one spreadsheet. Do this, open both files and go to one of the files (Workbook2), select the sheets and Right Click, now choose Move/Copy.. A box opens up, Choose Workbook1 on the To Book: dropdown list. and click OK. You are done.
2006-07-17 07:28:53 · answer #1 · answered by HotRod 5 · 0⤊ 0⤋
Try this...
Open both Excel document in the same Excel window. Right-click on the worksheet tab you want to copy and select "Move or Copy..." In the "To book:" dropdown choose the other document you have open. Do this for all of the worksheets you want to merge. Once they are in the other document, you can reorder them howeveryou like.
Hope that helps!
2006-07-17 07:33:13 · answer #2 · answered by Anonymous · 0⤊ 0⤋
Right-click on the tab at the bottom and select 'move/copy'. If you have both files open, you can select the file you want to move it to. If you get stuck, use the search option in the help file. It should show you step-by-step what to do.
2006-07-17 07:32:22 · answer #3 · answered by allyson71377 3 · 0⤊ 0⤋
Write click the tab at the bottom and select copy and move to
2006-07-17 07:28:56 · answer #4 · answered by Mark W 5 · 0⤊ 0⤋