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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Collapsing all groups 0
Header Row with Option to Shrink/Expand Rows Beneath 2
Adding a row to reconcile to a new worksheet 1
Pivot tbl rpt-how to return text in a field vs. a sum/count value 1
TITLE FOR A ROW GROUP 1
How do I subtotal specific / random rows from a spreadsheet? 1
creating a report from a table, pivot table not suitable 1

Top