How do I set up print titles in Excel? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
ON1 2/22/2005 2:37 AM PST
  Question
  I am using Office XP 2003 and I wish to have a print title for pages of my
Excel workbook. There is an option under print preview-->setup for rows to
repeat at top but this is greyed out and I cannot seem to make active. Is
this a bug or am I doing something wrong. Doing my head in . Please help!!!!O
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Maglor 2/22/2005 3:37 AM PST
  Answer
  You cannot activate it while in Print Preview-mode. You'll have to
return to the normal view.

Then, choose File - Page Setup - Sheet...

On Tue, 22 Feb 2005 02:39:01 -0800, ON1
<ON1@discussions.microsoft.com> wrote:

>I am using Office XP 2003 and I wish to have a print title for pages of my
>Excel workbook. There is an option under print preview-->setup for rows to
>repeat at top but this is greyed out and I cannot seem to make active. Is
>this a bug or am I doing something wrong. Doing my head in . Please help!!!!O

 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
ON1 2/22/2005 7:09 AM PST
   
  Sound Maglor. Should have figured that out but have been rushed and you know
whats its like after that.........Thanks a mill

"Maglor" wrote:

> You cannot activate it while in Print Preview-mode. You'll have to
> return to the normal view.
>
> Then, choose File - Page Setup - Sheet...
>
> On Tue, 22 Feb 2005 02:39:01 -0800, ON1
> <ON1@discussions.microsoft.com> wrote:
>
> >I am using Office XP 2003 and I wish to have a print title for pages of my
> >Excel workbook. There is an option under print preview-->setup for rows to
> >repeat at top but this is greyed out and I cannot seem to make active. Is
> >this a bug or am I doing something wrong. Doing my head in . Please help!!!!O
>
>
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies