Keeping Row 1 At Top When Scrolling?

  • Thread starter Thread starter KMc
  • Start date Start date
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.
 
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)
 
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.
 
You must log in or register to reply here.

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

Scrolling in Excel 2
How to fix the top-most 4 rows when scrolling? 1
top row stationary 9
Why does row one always appear at the top when page down 1
Keep column names at top of workbook 2
Can it be done? 2
How to make the scrolling not include the top rows of the sheet 3
Row Scrolling with a Page 1

Back
Top