Opening 2 Workbooks in Separate Windows

new4me

New Member
Joined
Nov 20, 2002
Messages
47
I have 2 workbooks open and I want to set up formulas from one linking to the other. When I toggle on the task bar between the 2 workbooks they replace each other within the same window so I can only see one workbook at a time. How do I set it up so I can have 2 separate windows open at the same time, one with each workbook in it? I tried 'side by side' in one window but the viewing area is too small.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
How is that not what you were looking for? BTW this is what I said to do in post #5, so I'm puzzled as to how this is now [sort of] the solution??? :confused:
 
Last edited:
Upvote 0
How is that not what you were looking for? BTW this is what I said to do in post #5, so I'm puzzled as to how this is now [sort of] the solution??? :confused:


I was trying for 2 separate windows because it gave me more room. When I used side by side, it opened all my toolbars in each window. This way it didn't.
 
Upvote 0
I was trying for 2 separate windows because it gave me more room. When I used side by side, it opened all my toolbars in each window. This way it didn't.

In order for that to happen, you would need to have 2 instances of Excel open. Which you said you didn't want..
 
Upvote 0

Forum statistics

Threads
1,215,944
Messages
6,127,835
Members
449,411
Latest member
adunn_23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top