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.

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)

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

Thanks so much. This video is good for new excel user like me.

very well explained. Keep posting new videos like this!

Excellent video again. Succinctly and clearly explained and demonstrated. Thank you for sharing.

Thanks so much...! Is there anyway to make the data group bigger without ungrouping first..?

This is wonderful, thank you. 👏

Thanks - is there a way to name groups in excel? I'm work with a large set of data and would like to group based on type

Thankyou very much. Just what I was wanting to know.

Thank you so much Sir 🎉🎉

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

Thank you! I can use this for my work.

What clear English!

can we create as a link to atlantic, central, northwest if we click on these names should be reflect under those

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?

Is it possible to sort grouped cells B3:F8 (or simply grouped rows 3-8), B9:F14 (or simply grouped rows 9-14), etc by cells B3, B9, etc?

You always have great tips for us TTS! Always brilliant and thank you so much!

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.

Thanks a lot for this video

Very good tips

Nice Explanation 🔥🔥 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.

Love it! ⏮

Thanks so much

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.

Thanks!

wonderful

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

collaboration

Video thumbnail does not come from video, does not show how to group like video thumbnail.