PivotTable - how do I hide page field when printing

[Guest]

Using Excel 2003 I have created a PivotTable. I have created one worksheet
for each province and on each worksheet I have selected one province from the
dropdown page field. Now I do not want this field to show either on the
worksheets or when I print. If I go to the page field, right click and
select "hide", the field disappears but the data in the table changes to
include all provinces. How can I hide the line but retain it's functionality?

Thanks for your help
Celia

 

[Guest]

Couple of thoughts.
1) Hide the row with the Page field on it.
or
2) right-click on the cell next to the Page field.
select 'Format cells...'
select 'Font'
select 'Color'
change the color to WHITE
now the info is there but no-one can see it

HTH,

 

[Guest]

Thank you so much Gary - that was exactly what I needed.

Regards,
Celia