View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default how do I have a heading row repeat on each page while working?

Hi

Place cursor in cell A2WindowsFreeze Panes

--

Regards
Roger Govier

"mephibosheth" wrote in message
...
In Excel 7 I am working on a large worksheet and need to have the first
row,
which I am using as a heading to label each column, repeat at the top of
each
page. I am able to do this for printing but I really need to be able to
view
it while working and can't seem to find a way to accomplish this.

I am a relatively new user and help would really be appreciated.