how do I display rows at top of page even when I scroll down??

[paullaup]

Does anyone know how to display rows (say rows 1,2, and3) at top of page even when I scroll down??
I've seen it on other spreadsheets, but I have no clue how to even search for it.

Any help is greatly appreciated

Thanks

 

[aviat]

Its called freezing. The following is from Excel help.

Keep row and column labels visible as you scroll

To freeze the top horizontal pane, select the row below where you want the split to appear.
To freeze the left vertical pane, select the column to the right of where you want the split to appear.

To freeze both the upper and left panes, click the cell below and to the right of where you want the split to appear.

On the Window menu, click Freeze Panes.

 

[paullaup]

Aviat,.. . THANKS A MILLION!!. I cant believe it was that simple!!

nice one!!