can i have more than one split in an excel worksheet
 

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

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

can i have more than one split in an excel worksheet
 

That's brilliant thanks very much.

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

Secret Genius.

can i have more than one split in an excel worksheet
 

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


Secret Genius wrote:

That's brilliant thanks very much.

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

Secret Genius.

--

Dave Peterson