Freezing both horizontally and vertically

A

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
 
M

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
 
Top