How do you lock rows for scrolling ?

[FISH]

Hello all,

I'm new to Excel and using Excel 2002. I can do basic functions and basic
sorting, but that's about it at this point.

I've seen some Excel spreadsheet that lock a few rows. Then when you scroll
up only the rows below the locked rows actually scroll.

For example if you have names in row 4 and all the details for each of those
names in rows 5-200, how can you lock row 4 to always stay visible on your
screen, even when scrolling down to view the rows in the 100's?

I hope explained this well enough to get some help...lol.


THANKS in advance !!!

 

[Doug]

Hello all,

I'm new to Excel and using Excel 2002. I can do basic functions and basic
sorting, but that's about it at this point.

I've seen some Excel spreadsheet that lock a few rows. Then when you
scroll up only the rows below the locked rows actually scroll.

For example if you have names in row 4 and all the details for each of
those names in rows 5-200, how can you lock row 4 to always stay visible
on your screen, even when scrolling down to view the rows in the 100's?

I hope explained this well enough to get some help...lol.


THANKS in advance !!!

Click on number '5' at the left hand side to select the whole row, then go
to Window and select 'freeze pane'

 

[FISH]

Perfect, Thank you.

Click on number '5' at the left hand side to select the whole row, then go
to Window and select 'freeze pane'