David Carter's series of Five Minute Tips aims to develop your skill at using Excel pivot tables. To test these formating tips for yourself, try them out on your copy of the pivot_practice.xls database.
The beauty of Excel is that you can format a spreadsheet any way you want. It's not quite so easy in pivot tables, and occasionally you can modify a pivot table only to lose the formatting when you recalculate via the Refresh option. Microsoft has added so many options over the years that it gets confusing. These tips should clarify matters.
Use the black down arrow to highlight columns and rows
At the top of the first column in your pivot table is a grey Field button giving the name of the field in the Row area. Usually it will be in about cell A4; in our example it's called P...
Register now to continue reading
It’s 100% free and provides unlimited access to the latest accounting news, advice and insight every day.