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

C

CraigScherer

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

bj

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

PegL

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

Gord Dibben

Craig

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

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

In your case, select D2


Gord Dibben Excel MVP
 
Top