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
|