Problems with Printing Titles

  • Thread starter Thread starter Fukilla
  • Start date Start date
F

Fukilla

Hi Everybody

I have problem with printing titles(file<print preview<pag
setup<sheet)

It's just inactive when i click on it :confused:

I would appreciate if anybody can help me

Thanx in advanc
 
Hi
any chance you have grouped some sheets (e.g. is the text [grouped}
shown in the caption of your Excel application)
 
I'm not sure what you mean by inactive.

Can you click in the 'Rows to repeat at top' box?
If so, you can type the row(s) that you want as titles: $1:$3
Or, select the rows on the worksheet, and the reference will be
entered in the box automatically.
Click OK

You'll see the print titles when you preview or print the sheet.
 
That is the normal behaviour. To specify title rows you need to use the path
File|Page Setup. That is to say, skip the Print Preview step.

Best wishes
 
Back
Top