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