Page
(1)
Worksheet
(1)
Dave.Thanks
(1)
Activecell
(1)

Show top three rows when scrolling

Asked By Doug Mc
20-Nov-09 06:11 PM
I thought I knew how to do this but it did not work.

I went to Page setup, Sheet and typed in $1:$3 but it did not work.
What am I doing wrong?

Thanks in advance.
Doug

It sounds like you set the rows to repeat at top when the worksheet is printed.

Dave Peterson replied to Doug Mc
20-Nov-09 06:17 PM
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 is visible)
select A4
Window|freeze panes

Everything above the activecell and to the left of the activecell will be
frozen.




--

Dave Peterson

Worked like a champ Dave.Thanks,Doug

Doug Mc replied to Dave Peterson
20-Nov-09 06:25 PM
Worked like a champ Dave.
Thanks,
Doug
Post Question To EggHeadCafe