HI - I'm not sure what this function is called, but I have seen other spreadsheets that are very long, and what has been done is to have a + or - button so it will expand the rows underneath. For example, Column A Row 1 would have Blue and Gold Banquet. Column B Row 1 would have the total cost from Rows 2-5. Row 2 and 5 would be suppressed underneath until that button is clicked. That way, there could only be maybe 12 rows (once completed) each reflecting a total cost, but, to drill down you can click the expansion button to show all of the subtotal costs etc? I've already received some great help on something else, does anyone have a suggestion?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
+/- expansion buttons within excel?
- Thread starter commodus
- Start date
I think what your looking for is advanced filters...I forget exactly where in older versions of exel (maybe data->filters->advanced filters?) but in excel 2010 on the homet tab there is a sort and filter option that migth help you out.
Upvote
0
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Welcome to the Board!
That's called Grouping & Outlining. Select the range of Rows you want to group then goto Data-->Group, which is on the Outline tab. Once you apply the grouping you'll have the expansion buttons.
If you want category totals, then you'd use Data-->Sub-Totals.
HTH,
That's called Grouping & Outlining. Select the range of Rows you want to group then goto Data-->Group, which is on the Outline tab. Once you apply the grouping you'll have the expansion buttons.
If you want category totals, then you'd use Data-->Sub-Totals.
HTH,
Upvote
0
Similar threads
- Question
- Solved
