Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    View Multiple Sheets in Workbook (Excel 2000)

    I have a workbook with 12 monthly sheets and 1 total sheet.

    I would like to be able to view one of the monthly sheets at the same time as the total sheet.

    Can anyone help? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Multiple Sheets in Workbook (Excel 2000)

    Colin,

    Open the workbook.
    From the menu Select Window | New Window
    Then from the Window menu Select Compare Side by side.
    If you only see one workbook, make sure it is not set to Maximum size.
    This works on Excel 2003 and I think it works on Excel 2000 as well.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: View Multiple Sheets in Workbook (Excel 2000)

    Alternatively:
    - Activate a monthly sheet.
    - Select Window | New Window.
    - Activate the total sheet in the new window.
    - Select Window | All Windows...
    - Tick the "Windows in active workbook" check box.
    - Select the option you prefer (horizontal or vertical)
    - Click OK.

  4. #4
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Multiple Sheets in Workbook (Excel 2000)

    Unfortunately, in Excel 2000 you don't get the option to Compare Side by Side. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  5. #5
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Etobicoke, Ontario, Canada
    Posts
    198
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Multiple Sheets in Workbook (Excel 2000)

    Thanks Hans, that did the trick. I figured it had something to do with "Windows in active Workbook" but I couldn't figure out the sequence. <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

Posting Permissions

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