Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have several spreadsheets that I want to combine into one new workbook with
each old spreadsheet as individual worksheet tabs. I am tired of toggling back and forth between mulitple opened files. Help. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Open the first file and adjust the file window so you have some grey
area around it in the Excel window. Then open the second file and adjust its window so that you can see a part of the first file's window underneath. (I would normally arrange the first window to occupy the left hand half of the screen and the second window to occupy the top half of the screen). Then drag the worksheet tab from the second window to the first - this will move the sheet into the first file (retaining the sheet name - make sure it is not the same as the sheet already in the first file) and the second window will close as there is no sheet in it (assuming you only have one sheet per file - if not, then close the second window and click No when asked if you want to save the file). You can then repeat this for subsequent files, and when all is done you can save the first file (maybe with a different name - use File | Save As) which will have all your sheets in there. Hope this helps. Pete On Aug 7, 10:36 pm, PrettyGAPeachSteelerFan wrote: I have several spreadsheets that I want to combine into one new workbook with each old spreadsheet as individual worksheet tabs. I am tired of toggling back and forth between mulitple opened files. Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
Excel worksheet consolidation | Excel Discussion (Misc queries) | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Discussion (Misc queries) | |||
Consolidation | Excel Discussion (Misc queries) |