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:

• Auto-insert the current time
• Working with 3D formulas
• Manually wrapping text