Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / June 2005

Tip: Looking for answers? Try searching our database.

In Excel 2003 print headings is unable to be used

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AndrewNZ - 07 Jun 2005 04:11 GMT
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 - 07 Jun 2005 13:46 GMT
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.)

> 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?

Signature

Dave Peterson

George Nicholson - 09 Jun 2005 21:02 GMT
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 File>PageSetup, all options *should* be available. If they
aren't, let us know & maybe someone can assist.

HTH,
Signature

George Nicholson

Remove 'Junk' from return address.

> When I go to Page Setup >Sheet the Print headings options are greyed out
> so I
[quoted text clipped - 3 lines]
> Is this feature printer specific? ie will some printers support this and
> others won't?
blanco - 20 Jun 2005 23:47 GMT
I am having the same problem, today, for the first time.
Signature

Blanco

> How are you getting to Page Setup?
>
[quoted text clipped - 11 lines]
> > Is this feature printer specific? ie will some printers support this and
> > others won't?
blanco - 20 Jun 2005 23:50 GMT
DISREGARD.  The worksheet was in a GROUP - duh!
Signature

Blanco

> 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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.