Interesting feature. Haven't used it yet but I see it being useful for grouping helper calculation columns. One suggestion: you can repeat entry rows in Division column to allow Filter compatibility. This way, you can Multi-sort by Division and Team or use a PivotTable for similar grouping display.
hi this is helpful however, how can I group a pair of 2 columns that are beside one another without them being group altogether, my columns do not have a single column to separate them so that's why everytime I try to group them, they ended up being group in a single button. I hope you could help me out sir, thank you
What about for grouping them so they stay together when you have the top row locked at set to filters? It doesn't work for me, the group separates (I'm tracking finances, so I want to have just one date with multiple dollar amounts and their subcategories)
Is it just me, or does it look like it puts the + symbol on the line below where it should go? To expand a group, you'd expect to click the + next to the group name, not the line below it.
how do you get the expand (+) to line up with its title? example you grouped the teams in the atlantic division but the + shows on the row for central...To me that looks like it would expand for Central and Atlantic have no other data. thanks
The "+" should be next to the main group.. however the way you showed is, you need to click next to the 2nd grouping (Central), for Group1 (Atlantic) to open up, which is odd.
That's exactly what's bothering me about this feature. Your headline needs to be offset, too. I really want to use this feature but the offset + makes it totally confusing.
cant we do this grouping process automatically, if suppose there is a larger data, do i need to do it manually or can use macros or even something similar to that ??
can you annotate those groups ? Like on the left hand side it has those plus minus symbols could names be added next to them so we know what data we are collapsing?
So I have a question I work in wfm and we have 3 different departments that have recurring meetings, Huddles, and etc is there a way I can create this in excel where it can constantly be recurring. Right now I have it on a calendar and I copy it over every month.
1:15 Once you know that shortcut or have completed the grouping once, you can use CTRL + Y to "redo" or "repeat" the step again. Just 1 less button to hold down (also no dialog box), but easier for me to remember when I want to repeat functions in Excel or any office program for that matter
@@ologistika Dude, you just saved me a lot of hand cramping. I thought that was only for setting absolute references. It’s the simplest thing but no one has ever said it. Thanks!
Thank you for your informative videos. I have a particular case in excel in which I couldn’t find any solution to it and I hope you can help me with it. If I have various numbers in column B, and I need these numbers to be (increased/decreased): - By 0.5 either to make it 20.5 or 19.5 - Or by 1 to make it either 21 or 19 - Or 2 to make it 22 or 18 …etc. The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example: - The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5 - The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12 - The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is. I hope you can find time to answer this very soon. Thanks again.
Personally think it's a complete waste of time unless you can name the groups. You would only group columns/rows for large data sets, and then would spend most the time opening and closing unnecessary groups. Frustrated with MS still not enabling this feature. Gave the vid a like anyway despite my annoyance
