Freezing both horizontally and vertically

[AA Arens]

I can freeze a pane horizonally and also vertically, but not both of
them. I once have seen it on an excell sheet, so it should be possible.

Bart
Excell 2003

 

[Ron de Bruin]

Hi Bart

Select Cell b2 and use Windwow>Freeze Panes

 

[MartinW]

Hi Bart,

Freeze panes will work on every row above and to
the left of the active cell.
Click in cell F6 and choose freeze panes and it will
freeze rows 1 to 5 and columns A to E.

HTH
Martin

 

[AA Arens]

Found it out at
http://www.learnthat.com/computers/learn.asp?id=420&index=11

Thanks all.
Bart