Seeing multiple sheets at the same time

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Seeing multiple sheets at the same time

  1. #1
    New Member
    Join Date
    Oct 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi there -
    I've recently switched from Quattro to Excel.

    I'm using Excel 2002 XP.

    I know this is possible, but I don't know what Excel calls it, so I can't figure out how to do it!

    I have 1 workbook open.
    I want to split my screen, so I can see part of Sheet A, and part of Sheet B. At the same time.

    Thanks in advance - I'm sure it's simple.

    Marion in NY

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Marion, I think what you are after is Window>New Window
    then select
    Window>Arrange>(pick your optiond from here either Tiled, Vertical, Horizontal, Cascade)

    Note: this is in Excel97 but i wouldn't think it was too different in 2000

  3. #3
    Board Regular
    Join Date
    Oct 2002
    Posts
    657
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    With your work sheet open, Select menu item Window-New Window. You will now have a "Book1:1" and a "Book1:2". (If Book1 was name of workbook) Size them to fit on screen side by side. You can select sheet A in one and Sheet B in other. Changes on one will reflect the other.

    Play with it a bit and save a few time to Ensure you don't loose your good stuff.
    Chas

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com