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

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.

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..