PivotTable - how do I hide page field when printing

C

Celia

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
 
G

Gary L Brown

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,
 
Top