Keeping Rows on the screen?

T

trvlnmny

I have used the first couple of rows as 'headers'. When I want to
print this spread sheet I have set up the options so that these rows
are repeated on every page. I would like to know if I can keep these
rows locked on the screen so that as I move up and down thru the data
I will always have these rows at the screen top?
Thanks for any and all help.
 
G

Gord Dibben

Select A3 then Window>Freeze Panes.

You could also have column A in view if you selected B3 and Window>Freeze Panes.


Gord Dibben MS Excel MVP
 
Top