Freeze top 2 rows - how

M

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
 
M

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!
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top