can i have more than one split in an excel worksheet

[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?

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

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

[Secret Genius]

That's brilliant thanks very much.

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

Secret Genius.

[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


Secret Genius wrote:
>
> That's brilliant thanks very much.
>
> Question is, can you scroll them together?.....
>
> Secret Genius.

--

Dave Peterson