Freezing a row with a catch...

[fisht]

Hi All-

I am looking to freeze row 18 in an excel sheet, however in doing so this really limits the amount of rows below row 18 that can be viewed and scrolled through.

I would like to know if there is any way that you could freeze row 18 and when you scroll down on the worksheet, you can scroll down past rows 1-17 and when row 18 reaches the top row it would lock there? And you would then be able to continue scrolling down the worksheet beyond row 18... Does that make sense?

Someone please help if you know how this could be achieved!! Thank you.

 

[Joe4]

If you scroll down the page until row 18 is the top row you see in Excel, then go to that row and select Freeze Panes, it seems to do what you want (as you scroll down further afterwards, it shows row 18 at the top).