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

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

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

freeze and split at the same time? 1
Freeze multiple rows/columns in Excel 2007 11
How can I print frozen panes to appear above print selection in Ex 1
How do i use multiple splits or frozen panes? 2
Need Help with Freezing/Splitting 2 Frames in Excel 2003 3
Any way to get Freeze Panes to work with Split View? 2
how do i find horizontal, vertical and cascade options 1
Freeze Vertical and Horizontal 4

Top