Pivot tables

Hello Michelle,

Hope you enjoyed your Microsoft Excel A|dvanced course with Best STL.

Thank you for your question regarding formatting a pivot table. In Excel 2007 this is done using the Design ribbon in the PivotTable Tools contextual tab. In the PivotTable Styles group, select the appropriate style.

If you wish to format the values then in the PivotTable field list section click the item and then click 'Value Field Settings' and make the approriate changes. These will then show in the PivotTable data area.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer