Rows to repeat at top

  • Thread starter Thread starter Coopfab
  • Start date Start date
C

Coopfab

We know how to repeat rows for printing, but want to be able to view, or
keep them stationary, the top 2 rows of the sheet while scrolling or paging
down.

Can this be done?

Thanks for your time and interest.

M. Cooper
 
drag the little bars on the scroll bars and then freeze panes on the window
menu
 
Hi

Select cell A3, and then from Window menu Freeze Panes.


Arvi Laanemets
 
If you choose any cell in Column A and do Window / Freeze panes then it will
freeze the rows above. If you pick any cell in any other column, it will
freeze the rows above and columns to the left of that cell. A cell in row 1
will just freeze columns to the left.
 
Exception.........Select A1 and Freeze Panes will freeze in the middle of the
window.


Gord Dibben Excel MVP
 
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

Print titles must be contiguous and complete rows or columns 3
Repeat top row 2
Repeat Rows at Top Problem 2
Page Setup: Sheet: Print Titles: Rows to Repeat at top 3
Rows to repeat at bottom 2
Page Number in Repeat Rows area 8
Rows to repeat at top 3
Excel Vertical to horizontal repeat after 16 rows 3

Back
Top