Rows to repeat at top

[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

 

[Keith Streich]

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

 

[Arvi Laanemets]

Hi

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


Arvi Laanemets

 

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

 

[Gord Dibben]

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


Gord Dibben Excel MVP