Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open multiple worksheets each in its own tab
I'm trying to open multiple Excel files and have them all appear in the same
workbook with each sheet in its own tab, but the Open command puts everything into its own window instead of adding it to the a new tab in the existing window. I can manually create a new tab and copy and paste the contents of another sheet into it but there must be an easier way!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open multiple worksheets each in its own tab
Hi,
This is the only way Excel behaves. It never opens all selected files into one workbook as individual tabs. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "gerschwynne" wrote: I'm trying to open multiple Excel files and have them all appear in the same workbook with each sheet in its own tab, but the Open command puts everything into its own window instead of adding it to the a new tab in the existing window. I can manually create a new tab and copy and paste the contents of another sheet into it but there must be an easier way!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open multiple worksheets each in its own tab
Hi gerschwynne,
There is a way might help you, but you need to put your worksheets in/as separated Excel files. Open the first one, then minimize only the worksheet (not the whole window). And then open the other files and minimize them. Now you can edit your different worksheet without any need to change the window. -- MFS22 "gerschwynne" wrote: I'm trying to open multiple Excel files and have them all appear in the same workbook with each sheet in its own tab, but the Open command puts everything into its own window instead of adding it to the a new tab in the existing window. I can manually create a new tab and copy and paste the contents of another sheet into it but there must be an easier way!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open multiple worksheets each in its own tab
gerschwynne wrote:
I'm trying to open multiple Excel files and have them all appear in the same workbook with each sheet in its own tab, but the Open command puts everything into its own window instead of adding it to the a new tab in the existing window. I can manually create a new tab and copy and paste the contents of another sheet into it but there must be an easier way!!! Why didn't you put all the worksheets in one big Excel file in the first place? Your computer memory limits how many worksheets there can be in a workbook. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to open multiple new worksheets | New Users to Excel | |||
Open multiple files into multiple worksheets of the same workbook | Excel Discussion (Misc queries) | |||
batch file to open multiple worksheets | Excel Discussion (Misc queries) | |||
How do I open multiple hidden worksheets all at once? | Excel Worksheet Functions | |||
Multiple worksheets open on starting Excel. | Excel Discussion (Misc queries) |