Rows to repeat at top

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
 
K

Keith Streich

drag the little bars on the scroll bars and then freeze panes on the window
menu
 
K

Ken Wright

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.
 
G

Gord Dibben

Exception.........Select A1 and Freeze Panes will freeze in the middle of the
window.


Gord Dibben Excel MVP
 
Top