How do you input multiple Excel worksheets, as tabs into one worksheet?

Question

I have about 10 Excel worksheets that I'd like to ideally present as one Excel doc with 10 tabs. Is there an easy way to create this?

I currently go to Insert>worksheet and then have to open each one of the Excel worksheets and copy and paste the contents of each into the new worksheets on the originals. What I'm asking for is an easier way to import those other worksheets without having to go gothrough that process. Ideally - something that says "imprt these Excel files as new worksheet tabs".

Answer 1

Much easier;
1. Open all the workbooks
2. Tile horizontally
3. Click and drag each sheet into the workbook where they need to be.

Answer 2

If you have 10 sheets already created, open two of them at the same time. Once you do this, right click the tab at the bottom-left corner of one of the pages and select Move or Copy. Once you do this an options box will appear. Select one of your worksheets in the To Book: box and select the other in the second box. Continue to do this until you have all 10 worksheets in one book. Make sure you are putting the worksheets into the same "book". Then, save this new document under a new name. You could also open up all 10 worksheets at once if you can keep them straight.

Answer 3

Copy the entire worksheet and paste it into new tabs on one excel file.


EDIT--
In addition you can copy the entire worksheet by going to Edit -> Move or Copy Sheets and copy the sheet to another file.

Only advantage is that you can copy multiple sheets at once but in your case since you have many files with just one worksheet. It may be no faster than doing copy and pasting.

Answer 4

This is what I would do,

Create your new blank worksheet.

Open all of your other 10 worksheets.

At the bottom of each of those, right click on the worksheet tab and select 'move or copy'

Choose 'move' and in the drop down box, select the name of your new worksheet to move the sheet to.

Do this for each of your worksheets. You'll end up with one workbook that includes all 10 worksheets.

Answer 5

Insert additional worksheets in your current document. Go to Insert on the top menue and select "worksheet." You may insert as many as you like. You can also move and copy the worksheets by going to the "Edit" menu and select "Move and Copy."

Good luck!

Answer 6

Open first spreadsheet you want to copy:
Click on Edit
Click on Move or Copy Sheet
Click on drop down box for "To book:"
Select (new book) - will open a new spreadsheet named Book 1
Tick Create a copy
Click OK

Open second spreadsheet you want to copy:
Click on Edit
Click on Move or Copy Sheet
Click on drop down box for "To book:"
Select (Book 1)
On "Before Sheet" select where in sequence you want to place the next spreadsheet
Tick Create a copy
Click OK

Follow above instructions for the remaining spreadsheets then you can file and save the combined spreadsheet (with 10 tabs) with what ever name you want.

Answer 7

Here's a workaround to writing a macro. This workaround assumes that all of your text entries are in continuous rows as would a macro. Let's say your data is in column A and the first row of data is row 2. 1. Insert a helper columns B & C (or if columns B & C are already blank, use those columns). 2. In column B of the first row of data (row 2), write the following formula: ="~"&a2 and then copy it down through all the rows of data. I used ~ because this character is unlikely to appear in any of your data (you'll see why later). 3. Open Word. Back in Excel, highlight and copy all the rows of column B and PasteText this into Word. 4. Highlight all text in Word and click Replace. Put ~ in Find What and = in Replace With, then click Replace All - No - Close. You should now have in Word what looks like an Excel formula. 5. Highlight all text in Word and click copy. 6. Back in Excel, in cell C2, click Paste down arrow and Match destination formatting. 7. You should now have the desired formulas in column C, so delete columns A & B. Voila!

Answer 8

cut and paste
Just do a select all and copy it, then go to the new workbook on a new worksheet, and paste it.

Answer 9

go to INSERT and then click on WORSHEET

Answer 10

Easiest way: Have someone else do it. :)