freeze horizontal and vertical panes at the same time in Excel

[Guest]

 

[David McRitchie]

Hi Bridgette,

see http://www.mvps.org/dmcritchie/excel/freeze.htm

To free both row 1 and column A, you select a cell that is
one past each so select cell B2 and then Window (menu), Freeze Panes.