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
TechTehTech

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
bigmck

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
TechTehTech

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
HammerHead

win 7 X64 Ultimate SP1
 
 
Two at Once

My System SpecsSystem Spec
21 Jul 2012   #5
TechTehTech

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
HammerHead

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
UsernameIssues

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




Similar help and support threads
Thread Forum
Excel Spread Sheets and Printing
Hi:The font in my Excel Spread Sheet will not print larger. It will display larger type but won't print larger. Thanks, Ardath Morrison
General Discussion
Saving spread sheets in open office
Have been using open office Spread Sheets for some time now, and saving results in Microsoft Excel 97. On the last occasion I tried saving in open office to see what would happen. It was saved as a SCX file, which I have not come across before When I tried opening it again it opened in Notepad as...
Software
what are the options to recover deleted sheets within an excel file? n
what are the options to recover deleted sheets within an excel file? nothing in the recycle bin excel file isnt in \AppData\Roaming\Microsoft\Excel autosave is set to 120 mins though it should have saved at least once...
Microsoft Office
Open Excel workbook in active window rather than first window
Hi, I have recently upgraded to Windows 7 and Office 2010 and though I'm starting to get used to all the changes there is one thing which is really bugging me. When I have two separate Excel windows open and open an Excel file from Windows Explorer the file will open in the first window not...
Microsoft Office
Excel Sheets Disapeared on one specific file.
Hello, i have Office 2010 installed in my company. a user edited an Excel workbook and somehow got the sheets to disappear. if i open a new workbook, they appear fine. i know the trick about maximizing, but it's not the case. i also tried the Home>format>visibility>hide/unhide i managed to...
Microsoft Office
Excel 2010 - Accessing data based on conditions from other sheets
I've tried goggling this a bit and can't seem to find exactly what I'm looking for. I'm trying to setup a sheet that can run calculations based upon what someone else enters (ex: if they select 'option1', preferably from a drop down list, then two values will be set to the corresponding values,...
Microsoft Office


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 06:19.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App