how to keep a permenant row on top

M

Mehrab

How do I keep the first row of a page on the top of the
screen to when I scroll down it stays up there?
for example, if I have titles on the top row, I would like
to see the titles on top even if I'm all the way at the
bottom of the page.
 
E

EZ Money

Select B2 and Windows>Freeze panes. The result will be that column A and row
1 are frozen. Everything above and to the left (US version) of your
selection will not scroll.
 
L

Laura Cook

Select A2 and go to Window > Freeze Panes.

If you want more than one row, say 3 rows, select A4 and Freeze Panes.

Same can be done with columns. If you want rows 1 and 2 to stay at the top
and columns A, B, and C to stay at the left, select cell D3 and Freeze
Panes.

Any columns to the left of your selection and any rows above your selection
will stay put when you click Freeze Panes.
 
J

Jordon

How do I keep the first row of a page on the top of the
screen to when I scroll down it stays up there?
for example, if I have titles on the top row, I would like
to see the titles on top even if I'm all the way at the
bottom of the page.

Window / Freeze Panes
 

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