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!
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
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.
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.
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?
I wish there was a way to use groups with a filter. Like if I wanted to sort the divisions from A to Z. Unfortunately, if the groups aren't already in alphabetical order, the groups will be messed up with this filter. Is there a way to fix this?
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)
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 ??
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.
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.
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.
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
or F4 to do it with just 1 button :D
@@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!
Thanks!
Thank you for your generous gift! I'm glad you found my video to be helpful. Thank you.
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
Yes! This. I'm having the same problem
Full of tanks for sharing this video , this is totally usefull bro !
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.
this sounds like gibberish to me
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.
Thank you so much so easy to understand
This is wonderful, thank you. 👏
Thankyou very much. Just what I was wanting to know.
Thank you so much Sir 🎉🎉
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
Thank you! I can use this for my work.
Nice Explanation 🔥🔥 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.
Agreed, he did it stupid.
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.
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?
Thanks so much...! Is there anyway to make the data group bigger without ungrouping first..?
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
I think u name them in d name box like how u name cells
I wish there was a way to use groups with a filter. Like if I wanted to sort the divisions from A to Z. Unfortunately, if the groups aren't already in alphabetical order, the groups will be messed up with this filter. Is there a way to fix this?
Thanks a lot for this video
Love it! ⏮
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)
You always have great tips for us TTS! Always brilliant and thank you so much!
Very good tips
can we create as a link to atlantic, central, northwest if we click on these names should be reflect under those
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 ??
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?
What clear English!
Hi! Is there a way to print the groups
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.
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.
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.
Thanks so much
Thanks
wonderful
great
Video thumbnail does not come from video, does not show how to group like video thumbnail.
collaboration
Thanks.awfully complex software
Thanks!
Thank you for watching! I appreciate your support!