RE: Freezing panes in Excel - Freezing columns and Rows!!

Dear Corinne

Thank you for attending Excel Intro and Intermediate courses. I hope you enjoyed the courses and benefited from them.

Freezing pane in Excel is little bit tricky especially when you have to freeze BOTH rows and COLUMNS.

But if you remember the basic rule mentioned below you can never go wrong!!

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, B and C you need to select Column D and then choose Windows > Freeze panes.

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

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, 3 and 4 and at the same time you want the Columns A, b and C to be frozen then the basic principle is the same. You need to be on cell D5 because Rows 1-4 are above 5 and Columns A-c 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