repeating rows in Excel worksheet on the display 1

[ranton220]

Does anyone know how to make the first row repeat whenever you scroll down an Excel spreadsheet? I've found out how to print out worksheets with the 1st row on each printed page but not how to make this happen on the video display.

Can anyone help me?

Thanks much!

 

[kpetursson]

Select the cell in column A below the lowest row you want to keep displayed. Then Click in the menu WINDOW --> Freeze Pane. This will "freeze" all of the rows above the one selected so the do not scroll with the rest of the screen. If you select a cell is any column other then A the columns to the left of the one you have select will also "freeze"

Alternatively you can use the 'split pane' also in the Window Menu


Kevin Petursson