Setting a row to stay on top
 

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

Setting a row to stay on top
 

Assume your col headers in A1 across
Select A2, click Window Freeze pane
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"timmyc" wrote:
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

Setting a row to stay on top
 

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.

timmyc wrote:

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

--

Dave Peterson