Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This is a question relating to Excel 2007 - Can you give groups names?

Is there any way of giving the grouping indicators a name rather than using 1, 2, 3 etc?

share|improve this question
Is this what you meant? Or did you mean the indicators above the + signs when you have subtotals – datatoo Feb 3 '12 at 23:12

Are you referring to the Groups you can create in pivot tables? If so, yes, you can.

After you create the group(s), you can select the group cell in the pivot table, then change its name in the formula edit space. I hope this screenshot conveys the idea:

enter image description here

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.