• split screen & view 2 pages within same workbook

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » split screen & view 2 pages within same workbook

    Author
    Topic
    #353227

    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

    Viewing 0 reply threads
    Author
    Replies
    • #516067

      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

    Viewing 0 reply threads
    Reply To: split screen & view 2 pages within same workbook

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: