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.

Continued...

» Register now

The full article is available to registered AccountingWEB 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.

Comments

Painters

sasasaassa | | Permalink

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.