Pivot Tip 22 - Format drill-down worksheets with the Format Painter
Posted by AccountingWEB in Technology, Excel on Wed, 19/07/2006 - 05:30
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.
To read the rest of the article you'll need to log in below
If you've forgotten your details click here for a reminder.
If you haven't got an account, it only takes a minute to set one up,
click here to register
- 5643 reads
- login or register to post comments
- Add to a social bookmarking site
Want to win £500 of digital photography goodies? 
Love it? Hate it? We want to know what you think of the new design and how we can make it even better. Post your views in our new 
Got an opinion you want to share with the rest of the community? Then login and