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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top