In Excel 2003 print headings is unable to be used
 

When I go to Page Setup Sheet the Print headings options are greyed out so I
cannot select any rows or culmns for this. The document spans 8 pages. I have
set the print area (but it is also greyed out in the Sheet options)
Is this feature printer specific? ie will some printers support this and
others won't?

Did you get to the page setup dialog via PrintPreview?

If yes, just try file|page setup.

Lots of options are disabled when you go through printpreview.

(And if your worksheets are grouped, some options are not available, too--on the
Sheet tab of that dialog for instance.)

AndrewNZ wrote:

When I go to Page Setup Sheet the Print headings options are greyed out so I
cannot select any rows or culmns for this. The document spans 8 pages. I have
set the print area (but it is also greyed out in the Sheet options)
Is this feature printer specific? ie will some printers support this and
others won't?

--

Dave Peterson

How are you getting to Page Setup?

When accessed via PrintPreview, some of the settings are greyed out. This is
true for everyone, by design. No way around it.
When accessed via FilePageSetup, all options *should* be available. If they
aren't, let us know & maybe someone can assist.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"AndrewNZ" wrote in message
...
When I go to Page Setup Sheet the Print headings options are greyed out
so I
cannot select any rows or culmns for this. The document spans 8 pages. I
have
set the print area (but it is also greyed out in the Sheet options)
Is this feature printer specific? ie will some printers support this and
others won't?

I am having the same problem, today, for the first time.
--
Blanco


"George Nicholson" wrote:

How are you getting to Page Setup?

When accessed via PrintPreview, some of the settings are greyed out. This is
true for everyone, by design. No way around it.
When accessed via FilePageSetup, all options *should* be available. If they
aren't, let us know & maybe someone can assist.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"AndrewNZ" wrote in message
...
When I go to Page Setup Sheet the Print headings options are greyed out
so I
cannot select any rows or culmns for this. The document spans 8 pages. I
have
set the print area (but it is also greyed out in the Sheet options)
Is this feature printer specific? ie will some printers support this and
others won't?

DISREGARD. The worksheet was in a GROUP - duh!
--
Blanco


"AndrewNZ" wrote:

When I go to Page Setup Sheet the Print headings options are greyed out so I
cannot select any rows or culmns for this. The document spans 8 pages. I have
set the print area (but it is also greyed out in the Sheet options)
Is this feature printer specific? ie will some printers support this and
others won't?