How do I get both horizontal and vertical frozen panes in Excell
 

How does one get both horizontal and vertical frozen panes in Excell
spreadsheets? Tried split as described by Microsoft and it does not operate
as desired. Am looking to have the first row be 'frozen' at the top when
scrolling down and the first 3 columns 'frozen' at the left when scrolling
across.

You should be able to select cell D2 and select freeze pane and have it do
what you want.

"CraigScherer" wrote:

How does one get both horizontal and vertical frozen panes in Excell
spreadsheets? Tried split as described by Microsoft and it does not operate
as desired. Am looking to have the first row be 'frozen' at the top when
scrolling down and the first 3 columns 'frozen' at the left when scrolling
across.

Unfreeze panes, then go to D2. Freeze panes, and that should set you up so
Row 1 is frozen and colums A-C are frozen.

"CraigScherer" wrote:

How does one get both horizontal and vertical frozen panes in Excell
spreadsheets? Tried split as described by Microsoft and it does not operate
as desired. Am looking to have the first row be 'frozen' at the top when
scrolling down and the first 3 columns 'frozen' at the left when scrolling
across.

Craig

The freeze panes rule is..........

Anything above and to the left of your selected cell will be frozen when you
go to WindowFreeze Panes

In your case, select D2


Gord Dibben Excel MVP

On Wed, 27 Apr 2005 06:24:04 -0700, CraigScherer
wrote:

How does one get both horizontal and vertical frozen panes in Excell
spreadsheets? Tried split as described by Microsoft and it does not operate
as desired. Am looking to have the first row be 'frozen' at the top when
scrolling down and the first 3 columns 'frozen' at the left when scrolling
across.