Once you have created your Pivot in Excel, you may decide to move it to an entirely new work sheet, or to a different location within the same work book to enable you to rearrange a dashboard or add...
Category: Pivot Tables
Excel Tip-How To Quickly Select All Or Just Parts Of Your Pivot Table
If you use Pivot Tables regularly and you either move them around, select parts of them or indeed all of them, then here is a really quick method for selecting areas of your Pivot with ease...with...
Excel Pivot Table Tip-Set Stable Widths On An Excel Pivot Table
Do you need to have your columns widths static, so when you refresh your Pivot Table it remains just as you want it it to?. This is really easy in Excel and something I use all of the time when I...
I find there are times when you do need to start right again from scratch with a Pivot Table, but removing all of the column fields, row fields, data fields, filters etc can take time. Excel of...
When you need to sort and rank a field within a large number of data items it can be confusing to determine the ranking of the data you are looking at if the list is too long, or you may want to turn...
I really do not like the way when you create a Pivot Table and add multiple fields to the Row or Column Label areas, subtotals are shown at the the top for outer fields. This just does not sit well...