Microsoft Excel: Combining multiple spreadsheets into one? - Tilted Forum Project Discussion Community

Jimellow · 08-01-2009, 06:58 PM

I have three to five independent spreadsheet (.xls) files, with identical formatting and row width. I'd like to combine them all into one workbook, yet pasting across different instances of Excel doesn't seem to maintain the original cell width, and the only option I see for importing is found via "Data > Import External Data", which ultimately tries to connect to the Internet and do things far more advanced than what I desire.

I can copy and paste perfectly well within a single workbook (Copy and then "Enter" when clicking on the other tab), but when I have two instances of Excel open and try to paste across them, no formatting is carried over.

Thus, I'm looking for a convenient way to achieve this so I can easily combine my three to five spreadsheet files into one uniformly arranged workbook/file.

If you can assist with this, it would be appreciated.

EDIT: It is Microsoft Office 2003.

LordEden · 08-01-2009, 07:00 PM

What version of Office are you using?

Jimellow · 08-01-2009, 07:07 PM

Quote:

Originally Posted by LordEden

What version of Office are you using?

Microsoft Office 2003.

Cynthetiq · 08-01-2009, 07:26 PM

copy the worksheets, to another file. copy them to the same file.

---------- Post added at 11:26 PM ---------- Previous post was at 11:24 PM ----------

Moving a Worksheet to Another Workbook (Tips.Net)

Summary: It is easy to move an Excel worksheet to another workbook following this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

As you develop more and more Excel workbooks, you may have the necessity of moving a worksheet from one workbook to another. You can do this by following these steps:

1. Make sure both the source and target workbooks are open.
2. Display the worksheet you want to move.
3. Choose Move or Copy Sheet from the Edit menu. This displays the Move or Copy dialog box. (Click here to see a related figure.)
4. Using the To Book pull-down list, choose the name of the target workbook. The list of worksheets in the Before Sheet list will change to reflect the workbook you selected.
5. In the Before Sheet list, select the worksheet that should come after the worksheet you selected in step 2.
6. Click on OK. The worksheet is moved.

vinceco252 · 08-03-2009, 12:13 PM

^You can also do this via a context menu by right clicking on the tab name. Everything else applies the same way.

Jimellow · 08-04-2009, 08:36 AM

Thanks for the replies and solution. The methods described above work very well and has allowed me to organize all my spreadsheets into one.

08-01-2009, 06:58 PM	#1 (permalink)
Jimellow Junkie	Microsoft Excel: Combining multiple spreadsheets into one? I have three to five independent spreadsheet (.xls) files, with identical formatting and row width. I'd like to combine them all into one workbook, yet pasting across different instances of Excel doesn't seem to maintain the original cell width, and the only option I see for importing is found via "Data > Import External Data", which ultimately tries to connect to the Internet and do things far more advanced than what I desire. I can copy and paste perfectly well within a single workbook (Copy and then "Enter" when clicking on the other tab), but when I have two instances of Excel open and try to paste across them, no formatting is carried over. Thus, I'm looking for a convenient way to achieve this so I can easily combine my three to five spreadsheet files into one uniformly arranged workbook/file. If you can assist with this, it would be appreciated. EDIT: It is Microsoft Office 2003. __________________ Desperation is no excuse for lowering one's standards. Last edited by Jimellow; 08-01-2009 at 07:06 PM..

08-01-2009, 07:26 PM	#4 (permalink)
Cynthetiq Tilted Cat Head Administrator Location: Manhattan, NY	copy the worksheets, to another file. copy them to the same file. ---------- Post added at 11:26 PM ---------- Previous post was at 11:24 PM ---------- Moving a Worksheet to Another Workbook (Tips.Net) Summary: It is easy to move an Excel worksheet to another workbook following this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.) As you develop more and more Excel workbooks, you may have the necessity of moving a worksheet from one workbook to another. You can do this by following these steps: 1. Make sure both the source and target workbooks are open. 2. Display the worksheet you want to move. 3. Choose Move or Copy Sheet from the Edit menu. This displays the Move or Copy dialog box. (Click here to see a related figure.) 4. Using the To Book pull-down list, choose the name of the target workbook. The list of worksheets in the Before Sheet list will change to reflect the workbook you selected. 5. In the Before Sheet list, select the worksheet that should come after the worksheet you selected in step 2. 6. Click on OK. The worksheet is moved. __________________ I don't care if you are black, white, purple, green, Chinese, Japanese, Korean, hippie, cop, bum, admin, user, English, Irish, French, Catholic, Protestant, Jewish, Buddhist, Muslim, indian, cowboy, tall, short, fat, skinny, emo, punk, mod, rocker, straight, gay, lesbian, jock, nerd, geek, Democrat, Republican, Libertarian, Independent, driver, pedestrian, or bicyclist, either you're an asshole or you're not. What's the best nation in the world? DO-NATION!

08-04-2009, 08:36 AM	#6 (permalink)
Jimellow Junkie	Thanks for the replies and solution. The methods described above work very well and has allowed me to organize all my spreadsheets into one. __________________ Desperation is no excuse for lowering one's standards.

08-03-2009, 12:13 PM	#5 (permalink)
vinceco252 Upright Location: Keller, TX	^You can also do this via a context menu by right clicking on the tab name. Everything else applies the same way.