grouping

[Guest]

this is about basic grouping. i have four columns four each week of a month.
i want to group them so that i can open it up for the month when needed.
tried selecting columns and going to DRAW but the GROUPING tab is not
highlighted

 

[Niek Otten]

Data>Group and outline

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| this is about basic grouping. i have four columns four each week of a month.
| i want to group them so that i can open it up for the month when needed.
| tried selecting columns and going to DRAW but the GROUPING tab is not
| highlighted

 

[Guest]

perfect, thanks.

 

[Guest]

Hi Niek - I have a follow-up grouping question.

My data is in date format mm/dd/yyyy and I want to group by week.
I have the analysis pak and my formula is WEEKNUM(C3)

Q: How do I display the Monday-date of that week in the pivot table chart?
My chart has the x-axis as 1,2,3,4....25,26....36 (this week)
(manager says "I don't want to know it is week 26, give me a date!!)

Thanks for your reply & assistance.
Jimbo213