Actual Tools
Forums list
New topics
Topics list
Search
Help
Login
Register


Topic: «Excel spreadsheets , Open 2 spreadsheets at the same time? » on forum: Technical Support   Views: 4604
 
Robert Morris
Registered user
 
 Posts: 4
Joined: 08/01/2011
Posted: 08/17/2011 12:23:53
 
 
 I need to open two different spreadsheets for comparison.  When I open one (which is OK) and then try to open a second, the second covers the first, thus no comparison.
Have I changed a setting I should not have?
Bob Morris
 
Top
Pim Joosten
Resident
 
 Posts: 549
Joined: 11/11/2010
Posted: 08/18/2011 02:33:19
 
 
 Hi Bob,

The solution lies in Excel. Choose View > Arrange All and you can select how the spreadsheets must be shown (Tiled, Horizontal, Vertical or Cascade). This is in Excel 2007 with the ribbon. I assume Excel 2010 will be similar. In Excel 2003 there should be a similar function, but I do not know which menu item you must select.

Hope this helps.
 
Top
Robert Morris
Registered user
 
 Posts: 4
Joined: 08/01/2011
Posted: 08/18/2011 06:24:20
 
 
Quote
Pim Joosten wrote:
Hi Bob,

The solution lies in Excel. Choose View > Arrange All and you can select how the spreadsheets must be shown (Tiled, Horizontal, Vertical or Cascade). This is in Excel 2007 with the ribbon. I assume Excel 2010 will be similar. In Excel 2003 there should be a similar function, but I do not know which menu item you must select.

Hope this helps.

Pim.......

Thanks for the answer but it is not the solution.  I'm using Windows 7 64x with Office 2007.
First instance opened in Excel has the 3 AMM icons (Move, Maximize, Mirror).
Any additional opening of a Excel workbook (completely different workbook) shows the Tiled worksheet but WITHOUT the 3 AMM icons (Move, Maximize, Mirror).
Does not solve the application of 2 different Worksheets on 2 different monitors.

Any other thoughts?

Bob Morris
 
Top
Pim Joosten
Resident
 
 Posts: 549
Joined: 11/11/2010
Posted: 08/18/2011 07:32:22
 
 
 Ah, it was not clear to me fr om your first post that you wanted to have a spreadsheet on 1 monitor and another on the 2nd monitor. That can be done.

The problem is that all MS Office programs actually open their spreadsheets, documents etc. as a window inside the main program window. However, when you only have one spreadsheet open, the window inside the window is not displayed and it appears to have a program window. The difference will appear when you open more than one window. In that case every spreadsheet is shown as the window inside the program window. The problem is that AMM can only work for a program window and not for a spreadsheet window. I do not know whether that is technically feasible, it could very well not be. In any case, currently AMM does not work for spreadsheet (or document) windows.

There is however a workaround to be able to see 2 different worksheets on 2 monitors, although it involves a little bit of manual labor. First spread out the program over the entire desktop by clicking the maximize to desktop button of the program window (the AMM button, not the regular Windows button) or the key combination ALT + NUMMULT wh ere NUMMULT is the multiply key on the numerical keypad. This will resize Excel over the 2 monitors. Then choose View > Arrange > Vertical and manually move the spreadsheets and adjust the sizes so that each one exactly fits one monitor. It is a little bit more work, but it does work and is helpful in my experience. You can also do this with word processors. You can use the same title bar button or key combination to restore to one monitor.

Does this help?
 
Top


User(s) reading this topic
Number of guests: 1, registered members: 0, in total hidden: 0
Forums list
New topics
Topics list
Search
Help
Login
Register



 
HomeProductsDownloadOrderContactsPress Map Privacy
Copyright © 2002-2024 Actual Tools. All rights reserved.

Windows and the Windows logo are trademarks of the Microsoft group of companies.