Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    I have a fairly complex spreadsheet with multiple tabs. What I want to do is display different tabs on different screens (I have a dual screen PC). But I cannot find out if Excel 2010 will support that. I have tried "New Window", "Split screen" and anything else that looks vaguely like splitting the spreadsheet up, but it will not do it.

    Does anyone have a solution to this? I don't want to create a second copy of the spreadsheet since it then means I can only edit on one screen.

    Thanks for any help

    Alan

  2. #2
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Well, I use 2007 and show two tabs from the same spreadsheet side-by-side fairly frequently - I use New Window, Arrange All, Vertical. Can you not spread the Excel window across both screens and have the two windows next to each other that way? They'd still be within the same XL window, but it would be on both screens, therefore the two tabs would display one on each screen?
    Beryl M


  3. #3
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    Yes, that works. Thanks. Not the most elegant solution, but better than nothing.

    Cheers

    Alan

Posting Permissions

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