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

Kashflow logo
Share this content

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...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

About AccountingWEB


Please login or register to join the discussion.

24th Jul 2009 22:22

Painters have lost their values because of the latest painting software that has revolutionized this field. Everyone now can easily paint whatever he/she wants. That's the reason why painters have lost their value but I still love San Diego Painter a lot. They are real painters.

Thanks (0)