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. In particular, a column of numbers will often show some numbers with no decimals, some with 1 decimal, some with 2, 3 or 4, making it virtually unreadable.
Format drill down worksheets quickly by copying over the formats from the original source database.
Go to the source database; click at top left to highlight the entire works...