In Excel 2003 print headings is unable to be used

G

Guest

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

Dave Peterson

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.)
 
G

George Nicholson

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Column Headings 2
Print Row Headings on left & right side 4
Print titles in Excel XP 1
How to copy print set up to other excel worksheets? 1
I want to print comments and the section is greyed out 2
Excel Fit to page print options in Excel 1
Excel I have a large (62pages) excel file that needs to be sent as a pdf but it is only exporting half !? 2
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1

Top