View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default can i have more than one split in an excel worksheet

You get one Window|freeze panes (or window|Split) per window.

But you could use multiple windows into that worksheet:

Window|new window
window arrange (vertical???)

And have two windows showing the same worksheet.

Click on the one you don't want and hit ctrl-w to close it when you're finished.

Secret Genius wrote:

I wish to have both left and right hand panes static and scrolling (left to
right) columns in between. Can this be done?


--

Dave Peterson