Grouping Rows

S

Seftyby

Just as a follow up to this, now that i have the project rows in Sheet 2, i
need to group them in 3's so that i can collape and expand to overall project
overviews or detailed view.

It there an easy way to group each project without doing them individually
by highlighting and going to DATA --> GROUP AND OUTLINE --> GROUP, which will
take some time if i have to do it for each project set!
 
T

Teethless mama

Select your range > Data > Subtotals > OK out


Seftyby said:
Just as a follow up to this, now that i have the project rows in Sheet 2, i
need to group them in 3's so that i can collape and expand to overall project
overviews or detailed view.

It there an easy way to group each project without doing them individually
by highlighting and going to DATA --> GROUP AND OUTLINE --> GROUP, which will
take some time if i have to do it for each project set!
Click to expand...
 
Top