Setting a row to stay on top

[Guest]

What I would like to know is how to have a row that stays the first row, when
I scroll down, so that whatever page I am on, and no matter how far down I am
on the page, I can see the subject of the columns I am filling in (for
example: name, address, city, state, zip, etc).

Any help would be awesome!!!

tim

 

[Guest]

Assume your col headers in A1 across
Select A2, click Window > Freeze pane

 

[Dave Peterson]

You can use Window|Freeze panes to freeze columns and rows.

Say you want to always see rows 1:5 and columns A:E.
Select A1 (just so you can see it)
select F6
window|freeze panes.

Every row above the active cell will be frozen.
Every column to the left of the active cell will be frozen.

Window|Unfreeze Panes
will put things back to "normal"

ps. If you're doing this with a filtered range, show all the data first, then
freeze panes. You don't want to freeze panes in the wrong spot.