Keeping Row 1 At Top When Scrolling?

K

KMc

How do i make it so that the top row, row 1, stays at the top of my sheet no
matter how far i scroll down the page?

Many thanks
Kev.
 
C

Chip Pearson

Kev,

Select cell A2 and then go to the Window menu and choose Freeze
Panes.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
A

Andy

Kev

Select cell A2 and then Window>Freeze Panes. This will keep row 1 at the
top. You can also use it to keep columns static too.

Andy.
 

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

Why does row one always appear at the top when page down 1
top row stationary 9
Scrolling in Excel 2
Highlight a complete row when scrolling 1
Delete 1 row of objects, not all on sheet Excel 2007 11
Excel Unable to use mouse for scrolling 5
Excel Is this possible?? 3
Can it be done? 2

Top