how do you create a floating row?

[Guest]

I'm trying to find out how to have a row that is constantly on screen and is
displayed as you scroll down and up.

Any help would be great full.

 

[Fred Smith]

If the rows are at the top of the spreadsheet, you want Windows>Freeze Pane.

Position the active cell below the rows, and to the right of the columns you
want to stay on the screen before you use it.