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
 

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

Similar Threads

Excell spread sheet: reinstate number of rows to 50 3
form buttons on sheet collapse on unhide - sometimes 5
How do number columns first, then the rows in an excel footer? 1
fifty thousand rows 5
Selecting rows. 3
Excel Unable to insert cut rows into Excel online anymore? 0
Rows to repeat at top 3
Copying & Dragging Cells & Keeping Rows On all Screens 2

Top