Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Show top three rows when scrolling
I thought I knew how to do this but it didn't work.
I went to Page setup, Sheet and typed in $1:$3 but it didn't work. What am I doing wrong? Thanks in advance. Doug |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Show top three rows when scrolling
It sounds like you set the rows to repeat at top when the worksheet is printed.
If you want to always see rows 1:3 on the display, then... Select A1 (just so it's visible) select A4 Window|freeze panes Everything above the activecell and to the left of the activecell will be frozen. Doug Mc wrote: I thought I knew how to do this but it didn't work. I went to Page setup, Sheet and typed in $1:$3 but it didn't work. What am I doing wrong? Thanks in advance. Doug -- Dave Peterson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Show top three rows when scrolling
Worked like a champ Dave.
Thanks, Doug "Dave Peterson" wrote in message ... It sounds like you set the rows to repeat at top when the worksheet is printed. If you want to always see rows 1:3 on the display, then... Select A1 (just so it's visible) select A4 Window|freeze panes Everything above the activecell and to the left of the activecell will be frozen. Doug Mc wrote: I thought I knew how to do this but it didn't work. I went to Page setup, Sheet and typed in $1:$3 but it didn't work. What am I doing wrong? Thanks in advance. Doug -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to fix the top-most 4 rows when scrolling? | Excel Discussion (Misc queries) | |||
How to change the amount of rows that is effected when scrolling. | Excel Worksheet Functions | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
excessive rows when scrolling down | Excel Worksheet Functions | |||
Rows turn grey while scrolling | Excel Discussion (Misc queries) |