Freeze top 2 rows - how

[Martin ©¿©¬]

Hi
Using 2007, How do I freeze the top 2 rows in a spreadsheet?
Freeze panes on the view tab will only give me the first row

 

[David Biddulph]

Select row 3 before you impose Freeze frames.

 

[Ms-Exl-Learner]

Just place the cursor in the 1st cell of 3rd row and give ALT+W+F and enter.

For example I want to freeze upto 5 rows then cursor should be placed in A6
Cell and if we give ALT+W+F and enter it will freeze the 5 rows

If this post helps, Click yes!

 

[Martin ©¿©¬]

Just place the cursor in the 1st cell of 3rd row and give ALT+W+F and enter.

For example I want to freeze upto 5 rows then cursor should be placed in A6
Cell and if we give ALT+W+F and enter it will freeze the 5 rows

If this post helps, Click yes!

--------------------

Thank you David & (MS-Exl-Learner)
That got me sorted