Results 1 to 2 of 2
  1. #1
    I have been prowling around the archives (thanks for a search engine that works!!), and have not seen any comments about this. I am sure there are, but I am guessing that my searching technique doesn't work well.

    I have an Excel file that has multiple worksheets. I need (well, it would make life easier) to view two worksheets independently. That is, I want to move around one worksheet without affecting the other, similar to the way Word allows you to split things. Is there a way to do this without using the Windows tile function, which wastes a LOT of screen space?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts
    If you want to view two worksheets in the same workbook:
    - Make sure that the workbook is active.
    - Select Window | New Window.
    - Select Window | Arrange...
    - Tick the check box "Windows of active workbook".
    - Select an option to arrange the windows (Horizontal, Vertical, ...)
    - Click OK.
    - You can view different worksheets in each of the windows, scroll them independently etc.

Posting Permissions

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