i discover that i cannot scroll in each part if i simply freeze p.

[Guest]

i discover that i cannot scroll in each part if i simply freeze panes. is
there another way i can create panes in worksheet that would allow me to
scroll in each pane independently?

 

[Arvi Laanemets]

Hi

For what do you want to use this feature? It's meant to keep some amount of
leftmost and/or topmost columns always visible. You scroll the remaining
part of sheet.

Arvi Laanemets

 

[P Daulton]

Try using Windows|Split instead?

Pascal

 

[Gord Dibben]

hhh

Try Window>New Window then Window>Arrange. I personally prefer "Vertical"
orientation.

Gord Dibben Excel MVP

 

[Dave Peterson]

Jim Rech posted this:

http://groups.google.com/groups?selm=eGtL9Sbu$GA.207@cppssbbsa03

It may do what you want (well, if you change it to Trues).

And I think that I've seen posts that this is built into xl2003. (but not sure)


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm