how to open multiple workbooks in one excel

[alk44]

how do i open multiple workbooks in one excel instance

[#2]

@alk44 

View Multiple Workbooks

https://www.excel-easy.com/examples/view-multiple-workbooks.html

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.

[#3]

@alk44 see attached screen shot form excel 2010

how do i do this in office 365?

[#4]

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

I hope that this information will help you better.

Thank you,
Nikolino
I know I don't know anything (Socrates)

[#5]

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

View multiple workbooks

1. Open all the workbooks that you want to view.

2. On the Window menu, click Arrange.

3.  

[#6]

@alk44 

You're right the previous info was accidentally for Mac.
I rummaged around in Microsoft and in internet as far as possible and didn't find anything concrete in this regard.
This usually means two things.

a) It is not possible.

or

b) Nobody has been interested in whether there is such a possibility.

My last information that is a bit relevant to the topic, unfortunately I can't help anymore.

https://docs.microsoft.com/de-de/office/troubleshoot/excel/force-excel-to-open-new-instance

I hope that someone else here in the forum can help you more

Nikolino

I know I don't know anything (Socrates)

Force Excel to open by default in a new instance

[#7]

Last yet this info that I could not find.

View files in split and multiple windows
https://support.microsoft.com/en-us/office/video-view-files-in-split-and-multiple-windows-8c6377a1-e...

Compare two or more worksheets at the same time
https://support.microsoft.com/en-gb/office/compare-two-or-more-worksheets-at-the-same-time-1deed3da-...

Ps. You said that your office version has no "window menu".
Maybe you could insert a picture with your version of Excel. Maybe we'll get on like this.

Nikolino

[#8]

@alk44 

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 sepe... . Please check latest comment from Excel team on this page.

[#9]

@Sergei Baklan 

how do i invoke MDI or SDI behavior?

[#10 · Accepted solution]

@alk44 

Its only SDI on latest versions of Excel

[#11]

@alk44 

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.