Forum Discussion
how to open multiple workbooks in one excel
how do i open multiple workbooks in one excel instance
Its only SDI on latest versions of Excel
10 Replies
This is an old post but someone may find it helpful.
Easy. Open the first excel workbook (or a blank one).
Select all the workbooks you want in the same instance and drag them over to the open workbook sheet.
Don't worry, it won't insert any workbooks into the initial workbook.
It will open each workbook individually with the same instance as the initial workbook.
You can then create another instance and load a group of workbooks in that instance too.
Get into the habit of just opening workbooks by dragging over to the instance you want to avoid issues.
I guess you mean MDI, discussion about that is here Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window) . Please check latest comment from Excel team on this page.
Its only SDI on latest versions of Excel
View multiple panes, sheets, or workbooks
Excel for Microsoft 365 for Mac, Excel 2019 for Mac, Excel 2016 for Mac
https://support.microsoft.com/en-gb/office/view-multiple-panes-sheets-or-workbooks-fcdfb33e-5168-470d-a3d6-7ef1663599f3?ui=en-us&rs=en-gb&ad=gb
I hope that this information will help you better.
Thank you,
Nikolino
I know I don't know anything (Socrates)that site talks about a 'window menu'.
my office 365 excel doesn't have a window menu.
https://support.microsoft.com/en-gb/office/view-multiple-panes-sheets-or-workbooks-fcdfb33e-5168-470d-a3d6-7ef1663599f3?ui=en-us&rs=en-gb&ad=gb :
View multiple workbooks
Open all the workbooks that you want to view.
On the Window menu, click Arrange.
View Multiple Workbooks
The third-party products or Infos that this article discusses are manufactured by companies that are independent of me.
I makes no warranty, implied or otherwise, about the performance or reliability of these products or Infos.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
* Beware of scammers posting fake support numbers here.
