Is there any way to control the format of the column labels on a pivot
table, other than reducing the fontsize? When I view the pivot table
in Print Preview, it's split over 2 sheets widthwise, even in
landscape mode. There's a lot of wasted space because, although the
values are small (fixed format numbers), the labels on the column
headings are a good bit longer (e.g. Anaesthesia). It would be nice to
be able to have the labels print vertically so the column width could
be reduced, but I can't see a way of doing this.

Cheers,

Dave

Are you trying to view it as a query or report. Reasonably sure you can't do
it in a query, but all things possible with a report

Phil
<D.Stone (AT) ed (DOT) ac.uk> wrote