up vote 2 down vote favorite
share [g+] share [fb]

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?

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

1 Answer

up vote 1 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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