Pivot Tip 22 - Format drill-down worksheets with the Format Painter

David Carter's series of 'Five Minute tips' aims to develop your skill at using Excel pivot tables. If you want to test the tip for yourself, David takes you through a worked example on the 'pivot practice' database.

One of the great features of pivot tables is drill-down ' you can double click on any total and Excel creates a new worksheet showing all the transactions that make up that total.

But unfortunately the new worksheet is often poorly formatted.