Problems with Printing Titles

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fukilla - 16 Oct 2004 07:03 GMT

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

Reply to this Message

Frank Kabel - 16 Oct 2004 07:15 GMT

Hi
any chance you have grouped some sheets (e.g. is the text [grouped}
shown in the caption of your Excel application)

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Hi Everybody
>
[quoted text clipped - 12 lines]
> Fukilla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15357
> View this thread: http://www.excelforum.com/showthread.php?threadid=269793

Reply to this Message

Debra Dalgleish - 16 Oct 2004 12:52 GMT

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.

> Hi Everybody
>
[quoted text clipped - 6 lines]
>
> Thanx in advance

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Bernard Liengme - 16 Oct 2004 14:23 GMT

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

Signature

Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address

> Hi Everybody
>
[quoted text clipped - 6 lines]
>
> Thanx in advance

Reply to this Message