Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Split Screen (XL2000 SR-1)

    I know this is probably a basic excel technique but I can't figure it out.

    How can you split the screen with each window showing different sheets from the same workbook?

    It is tedious trying to build formulas that reference the other sheet when you have to keep clicking the sheet tab - if I could just see the other sheet on the left or right of the screen, well, that would be too good!
    - Ricky

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split Screen (XL2000 SR-1)

    File|Window|New Window then File|Window|Arrange to choose whether you want horizontal or vertical tiling. Adjust the resulting borders to suit. HTH
    Gre

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Links, Anyone?(XL2000 SR-1)

    That helped <img src=/S/doh.gif border=0 alt=doh width=15 height=15>, Thank you.

    Now, what's the best way to track down a link?
    - Ricky

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Links, Anyone?(XL2000 SR-1)

    I just discovered this previous post from Legare about links. Think I'll give it a try.
    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=62772&page=&v iew=&sb=&o=&vc=1>Post</A>
    - Ricky

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links, Anyone?(XL2000 SR-1)

    Ricky

    I'm not sure what you're asking for. (You do know how to do a search on the Lounge by now, don't you?) If you're just looking to remove them, try the attachment to . Have a look at <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=103306&page=& view=&sb=&o=&vc=1#Post103306>this post to see some comments on use.

    HTH
    Gre

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Links, Anyone?(XL2000 SR-1)

    Thanks Unka, I appreciate the help - I did a search AFTER I asked the question which is a bit sdrawkcab I suppose. The Manville utility found the two links and I promptly deleted them. Problem solved.
    - Ricky

Posting Permissions

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