Formatting Pivot Tables

When formatting a Pivot Table is best to right click the values section of the report and choose Number Format.

PT_Format_tip

This will format the whole report, not just the selected range. Avoid using the Format Cells option as it only applies to the range selected.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.