Viewing spreadsheet data in a split window
Viewing spreadsheet data in a split window
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Viewing spreadsheet data in a split window

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

    Default

     
    Hello!

    Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately.

    Any suggestions would be greatly appreciated!
    Thanks!

  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

    On 2002-03-27 20:46, DorenM wrote:
    Hello!

    Is it possible to view data in multiple columns running down a spreadsheet tab, in multiple windows side by side? I'm creating dynamic calculation "forms" that cost out a project with multiple parts, and need up to 20 parts on a spreadsheet tab. I currently have these forms running down the spreadsheet so that all viewable data is in columns A-H. I then need to view the costs of the first "part" against the other 19, hopefully side by side. I was hoping to just be able to programatically split the spreadsheet so that the left window would be frozen on the first instance, and then all of the others could scroll down the right window. Unfortunately the split only provides one vertical scroll bar, so both windows scroll together instead of separately.

    Any suggestions would be greatly appreciated!
    Thanks!

    Have you tried Window, New Window, Arrange, Vertical

    This will give you 2 windows with the same workbook and you can have the same worksheet in both windows

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks Sam! That works well, as long as all the rows are the same height. (I'm comparing data from one window to the other, so need the rows to line up.)

    Thanks again!
    D.

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