Freezing Panes

Dear Jenny

Thank you for attending Excel Advanced courses I hope you enjoyed the course and benefited from it.

The Basic rule of freezing pane is:

Any Rows ABOVE the selected Row gets frozen.
Any Column on the LEFT of the selected column gets frozen.

For example, if you want to freeze columns A and B you need to select Column C and then choose Windows > Freeze panes.

If you want to freeze Rows 1 and 2 then you need to select row 3 and then choose Windows > Freeze panes.

Freezing BOTH ROWS AND COLUMNS is a bit tricky:

If you decide to freeze both Rows and Columns then you need to be on a specific CELL. E.g. if you decide to freeze Rows 1, 2, and 3 and at the same time you want the Columns A, and B to be frozen then the basic principle is the same. You need to be on cell C4 because Rows 1-3 are above 4 and Columns A-B are on the left of that cell.

I hope this helped to answer your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!


Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003