Hints and tips home » Excel hints and tips » Pivot table grouping
Pivot table grouping
If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.
When you double click on this cell it will either expamd or collapse your grouped area
Added by Meenesh on 23rd October 2006
More Excel hints and tips, like:
|
» Forum post: Named cells |



Course updates

