Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-07-2010
Member
 
Join Date: Jun 2009
Posts: 1,518
Cannot open two excel files side by side in Windows 7

I have Office 2007 installed on my computer running Windows 7. I need to open and work on a lot of Excel sheets at a time. For this I tried to open and work on two excel files side by side but it didn't worked. Windows allows me to only work on a sheet at a time. Is there any way to open 2 excel sheets side by side? How?
Reply With Quote
  #2  
Old 31-07-2010
Member
 
Join Date: May 2008
Posts: 860
Re: Cannot open two excel files side by side in Windows 7

Windows 7 has a feature know as Snap which allows you to resize open windows simply by dragging them to the edges of your screen. Depending on where you drag a window, you can make it expand vertically, take up the entire screen, or appear side-by-side with another window. Snap makes reading, organizing, and comparing windows well to get the clear picture. It is an inbuilt feature and so you don't have to install anything.
Reply With Quote
  #3  
Old 31-07-2010
Member
 
Join Date: Jun 2009
Posts: 1,518
Re: Cannot open two excel files side by side in Windows 7

Thanks for your information but then how to use it and where will I get this feature? Will it be helpful in my case as I am cannot open two Excel files and put them side by side?
Reply With Quote
  #4  
Old 31-07-2010
Member
 
Join Date: May 2008
Posts: 860
Re: Cannot open two excel files side by side in Windows 7

Yes it will work. You can click/drag, move, and resize your two spreadsheets as needed. Just open the Excel files that you want to view side by side. Go to the View tab, and in the Window section click the "View Side by Side" button. You should see both of your sheets at the same time.
Reply With Quote
  #5  
Old 31-07-2010
Member
 
Join Date: Nov 2008
Posts: 1,514
Re: Cannot open two excel files side by side in Windows 7

There is yet another way to open your excel sheets in the way you want. If you have tried the above method then you might notice that the two sheets would appear either appear horizontally or vertically but you are not allowed to move your sheets in your own desired way. What if you want to make all your sheets appear in TILE or CASCADE? For this, open the two files, click on the View tab; in the Window section click "Arrange All" and chose between tile, vertical, horizontal or cascade and click ok button.
Reply With Quote
  #6  
Old 01-02-2011
Member
 
Join Date: Feb 2011
Posts: 2
Re: Cannot open two excel files side by side in Windows 7

The solution to the problem is to open Excel a second time and open the 2nd document from there. You can then move each windows separately.
Reply With Quote
  #7  
Old 02-02-2011
Member
 
Join Date: Dec 2010
Posts: 87
Re: Cannot open two excel files side by side in Windows 7

Quote:
Originally Posted by MarkWaterhouse View Post
The solution to the problem is to open Excel a second time and open the 2nd document from there. You can then move each windows separately.
Welcome to the forum. Appreciated that you have come with the solution, but I really want to know if you were saying to open the Excel Sheet and then open the Excel documents from the open option that that you get after making a click on the Microsoft Office Button. Let me know if I get it right. If you meant to say something else then would like to hear the same in your next post and this is the solution to all the other users that are having this trouble. You can open two Excel Sheets in Windows 7 in this manner.
Reply With Quote
  #8  
Old 02-02-2011
Member
 
Join Date: Feb 2011
Posts: 2
Re: Cannot open two excel files side by side in Windows 7

Thanks Mewad for your comments.
Yes I am saying open Excel 1st.
The 1st Document you can open it which ever way you want.
But the second sheet you need to open Excel 1st from your Start/All Programs/Microsoft Office/Excel or what other Short cut you use and then within Excel click on Open from the Microsoft Office Button.

You can now have one Excel sheet on one screen and the other on a 2nd screen.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Cannot open two excel files side by side in Windows 7"
Thread Thread Starter Forum Replies Last Post
How to get side by side row labels in Excel 2007 Pivot Table The-Farmer MS Office Support 2 15-02-2012 06:01 PM
How to turn on View Side by Side Sheet option in Microsoft Excel Rish!On MS Office Support 2 18-01-2012 05:44 PM
Side-by-side scrolling not working in Windows 8 RaaginiO Operating Systems 7 16-12-2011 04:15 PM
How to open 2 excel files in separate windows to view them side by side Barraq Windows Software 4 16-04-2011 02:49 AM
Windows Side-by-Side Errors Stumping Me! MSFT Windows XP Support 2 06-06-2006 08:24 PM


All times are GMT +5.5. The time now is 10:47 PM.