Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: How to open two Excel sheets in their own window


20 Jul 2012   #1

Windows 7 Home Premium, 64 Bit
 
 
How to open two Excel sheets in their own window

I know before we upgraded, I could open two separate excel files in their own windows, so I can compare, etc without switching back and forth.

I have the newest MSO and running Windows 7 Home Premium.

Thanks so much in advance! b(^_^)d


My System SpecsSystem Spec
.

20 Jul 2012   #2

Windows 7 Home Premium 32-Bit - Build 7600 SP1
 
 

I am guessing you have MS Office 2010. I don't have that version but try this. Open two spreadsheets, click on "Window" and you will see "Compare Side By Side". That will put both of them on the screen at one time.
My System SpecsSystem Spec
20 Jul 2012   #3

Windows 7 Home Premium, 64 Bit
 
 

Yeah I don't get those options. Either I'm clicking on the wrong thing (I'm sure I'm not - but who knows, blond moments happen to everyone) I don't get those options popping up.

When I go back to the office on Sunday morning, I'll take some screenshots, to better show what I'm talking about

Or you can read my mind
My System SpecsSystem Spec
.


20 Jul 2012   #4

win 7 X64 Ultimate SP1
 
 
Two at Once

My System SpecsSystem Spec
21 Jul 2012   #5

Windows 7 Home Premium, 64 Bit
 
 
Two at once

I get side by side View in the same window, but I may as well cycle to looking at one at a time, since they do everything in unison. I'll take a mini vid of all the options it gives me, but I do not get those options as well /facepalm. I'm in the office at the crack of dawn tomorrow.
My System SpecsSystem Spec
21 Jul 2012   #6

win 7 X64 Ultimate SP1
 
 
Question

Are you trying to open two instances of the same spreadsheet? If so I would make a copy of the spreadsheet (with a different name) and then open the original and then open the copy.
My System SpecsSystem Spec
22 Jul 2012   #7

W7 Pro SP1 64bit
 
 

Quote   Quote: Originally Posted by TechTehTech View Post
I get side by side View in the same window, but I may as well cycle to looking at one at a time, since they do everything in unison....
So, it looks like you found the side by side button - but it is not exactly what you had hoped for. You can turn off the "do everything in unison" feature with just one click.

It also sounds like you have a different layout to your tool bars since you said that you don't see the options mentioned in this post (Two excel spreadsheets in Windows 7). A mini video of what you do see would be great.

In the mean time, here is a video for turning on Side by Side and then turning off Synchronous Scrolling. This is from a fresh install of Office 2010 - so the tool bars should be normal.

Note: two spreadsheets are selected on the desktop before the video starts. Right clicking and selecting open - opens them both. You might want to watch the videos in full screen mode and at the highest resolution; otherwise, the tool tips might be hard to read.




And here is a video of how to just arrange windows - I picked vertical, you might want horizontal. Notice near the end that I arrange them again because I wanted book1 on the left. The spreadsheet that is selected when you arrange them will be placed on the left of the vertical view and on top in horizontal arrangements.




And finally, here is how to do this manually:

My System SpecsSystem Spec
Reply

 How to open two Excel sheets in their own window




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:24 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33