Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Oct 2004
    Location
    Houston, Texas, USA
    Posts
    242
    Thanks
    1
    Thanked 0 Times in 0 Posts

    2 worksheets on 2 monitors in Excel 2010, Windows 7

    I would like to be able to show 2 different worksheets on 2 different monitors. ALl I heve been able to find is that I need to open 2 copies of Excel in order to do so. However, I have always been told not to open multiple copies of a program.
    What I can do to show the 2 different worksheets on 2 monitors?

    Thanks,

    itconc

  2. #2
    Silver Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,860
    Thanks
    80
    Thanked 408 Times in 371 Posts

    Stretching exercises

    Try starting only one instance of excel then stretching the window across both screens. Now open both spreadsheets within Excel and stretch each to fit each monitor. Do not use the maximize button. Assuming that the second monitor is set to "Extend my desktop"

    HTH,
    Maud

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    7,462
    Thanks
    265
    Thanked 1,050 Times in 961 Posts
    itonic,

    You can do the following:
    1. Open Excel.
    2. If Excel is maximized on one of the screens click the Size box, to the right of the Red X. If not goto 3.
    3. Drag Excel's borders to span your two screens and adjust to the desired size.
    4. Open your 2 files.
    5. Click on the View tab,\.
    6. Click on Arrange All.
    7. Click on Vertical.
    8. Use mouse to size as desired.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,113
    Thanks
    92
    Thanked 310 Times in 299 Posts
    Hi

    There is nothing wrong in opening multiple copies of Excel.
    You can then easily show different workbooks on two screens.
    If you want to see two different worksheets from the same workbook on two screens, just remember that when you open the same workbook in a second instance of Excel, it will be then be in read-only mode.
    So you should only make any changes you want to keep in just one of the 'windows'.

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •