Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.