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. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,089
    Thanks
    39
    Thanked 189 Times in 176 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

  4. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    5,960
    Thanks
    193
    Thanked 730 Times in 666 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


  5. #4
    Bronze Lounger
    Join Date
    Mar 2002
    Location
    Newcastle, UK
    Posts
    1,474
    Thanks
    22
    Thanked 167 Times in 163 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
  •