can i have more than one split in an excel worksheet

S

Secret Genius

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

Dave Peterson

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.
 
S

Secret Genius

That's brilliant thanks very much.

Question is, can you scroll them together?.....

Secret Genius.
 
D

Dave Peterson

This kind of macro worked for me in xl2003 if both windows were showing the same
worksheet:

Option Explicit
Sub SyncWindows()
Windows.Arrange ActiveWorkbook:=True, _
synchorizontal:=True, syncvertical:=True
End Sub
 
Top