Show top three rows when scrolling

  • Thread starter Thread starter Doug Mc
  • Start date Start date
D

Doug Mc

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
 
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.
 
Worked like a champ Dave.
Thanks,
Doug



Dave Peterson said:
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.
Click to expand...
 
Back
Top