Solved Why is view different in MS Word versus Excel?

November 18, 2016 at 04:27:37
Specs: Windows 7
MS Office allows me to open multiple Word Documents and I can view they side-by-side in separate windows. Excel does not allow this. I can open multiple windows in PowerPoint and Outlook Email too. Just not Excel. Why is that?

See More: Why is view different in MS Word versus Excel?

Report •

#1
November 18, 2016 at 04:53:47
What happens when you try open multiple workbooks? I have no trouble opening multiple files when I reduce the size of the maximized window.

Report •

#2
November 18, 2016 at 05:01:16
Multiple workbooks can be arranged inside a single Excel window. This is not a problem. My question is in comparison to MS Word where multiple documents appear in separate windows.

The MS Word approach is far superior for manual comparison side-by-side. That is why I want it for MS Excel too. The side-by-side provided within a single Excel window is different (and in my opinion) not as good as the separate windows.


Report •

#3
November 18, 2016 at 05:27:30
✔ Best Answer
Have you tried opening multiple instances of Excel as opposed to opening multiple workbooks within the same instance? That should give you separate windows for each workbook.

Open one workbook in Excel and then, instead of opening a second workbook, open Excel again and then open the second workbook. (You can do this by right-clicking the Excel workbook button in the task bar and choosing Microsoft Excel)

There are some features that will be disabled, such as copying formulas from one instance to the other (it will paste values only) but if viewing is your goal, that might work for you.

Let us know.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
November 18, 2016 at 06:40:59
There may be some difference in your Excel Configuration, but what you're describing is exactly what I'm seeing. Two Excel workbooks side by side (separate windows), just the way Word is showing two different Documents.

So, what exactly happens when you try and open a second Workbook? Are you not able to reduce the size of the window and then open another one?


Report •

#5
November 18, 2016 at 07:16:38
beachyhbt :

How did you open the 2 workbooks? If I open a single instance of Excel, then open 2 workbooks, then choose View Side by Side, the workbooks open in 2 what I'll call "panes" within the same Excel window. Yes, Excel calls them Windows, but they are really more like "Panes within a Window". I can't grab one workbook and drag it to a second monitor (unless I expand the main Excel window across both monitors).

In Word, a completely separate instance of Word opens, which I can move around the screen(s), minimize one to the task bar, etc. In Excel, the only way that I can accomplish the same thing is to open a separate instance of Excel and then open the second workbook within that instance. I think that that is the difference that QwertyKPH is asking about.

Word acts similar to right-clicking a link in a browser and choosing "Open in a new window". A separate instance of the browser opens in a new window. Excel is similar to "Open in a new tab" since all workbooks are open in the same Excel window and must be arranged within that window for viewing.

I could be missing something, but that's how it's always worked for me.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#6
December 2, 2016 at 02:26:15
Thank-you very DerbyDad03 much for that advice. I now know that clicking a filename from Windows explorer will always open a workbook in the same Excel instace if I have previously opened Excel. Now I can open a second instance of Excel from the Windows menu, then use the new instance of Excel to open another file and achieve the desired result of two segregate instances of Excel!!!

Funny that I never knew that. I was a 'top contributor' on Yahoo answers back in 2006-07 for Excel formulas. Same name QwertyKPH. I've gotten away from Excel in the last 7 years so It's good to get back into learning more again. I really appreciate you solved this for me.


Report •

#7
December 2, 2016 at 11:09:32
We all can't know everything. If we did, there would be no need for these forums. ;-)

Glad I could help. Pass it forward.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

Ask Question