Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    split screen & view 2 pages within same workbook

    Hi,

    This is probably simple but I can't seem to find out how to do it. I used to be able to in Lotus quite easily.

    I have a multipaged workbook. I would like to link several cells on one worksheet to a previous worksheet. It's a matter of showing results in several different ways.

    I can split the screen but only for a given page. I want to be able to see worksheet A on the left and worksheet C on the right, so that I can just click on each cell as I link it, rather than going back and forth between pages. Can someone please tell how .

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: split screen & view 2 pages within same workbook

    Select Menu item Window, then New Window then go back to Window, Arrange and select Vertical
    This should give you two windows, one on the left the other to the right. You can then select a different sheet in each window.

    Good luck,

    Andrew C

Posting Permissions

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