Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get my formula to stay the same | New Users to Excel | |||
Autofit does not stay on. | Excel Discussion (Misc queries) | |||
How can I get a row # to stay when I delete a row? | Excel Worksheet Functions | |||
Toolbars will not stay where I put them | Excel Discussion (Misc queries) | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |