View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Doug Mc Doug Mc is offline
external usenet poster
 
Posts: 42
Default 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