Grouping Rows and Columns in Excel

Learn how to organize your Excel data better by grouping rows and columns. This organizing technique can make it much easier to focus on the specific data in Excel that's relevant to the viewer at a particular time. It's not a hard skill to learn, but there are several key points that you need to understand in order to group rows and columns effectively. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: bit.ly/groupexcelrows #excel #exceltutorials #microsoft365

[@frederickang1575]

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.

[@orlahastings4563]

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

[@fernandoherranz4095]

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

[@rwkholesawsnz]

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

[@MunirNawaz]

very well explained. Keep posting new videos like this!

[@katherine1768]

Thank you! I can use this for my work.

[@supakornboy6748]

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

[@kathleenbabb7023]

This is wonderful, thank you. 👏

[@RISK360NLP_NNT_AI]

Nice Explanation 🔥🔥 Thanks

[@haminatbakare7250]

Thanks a lot for this video

[@jaydeedino7180]

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

[@KDReese423]

Yes! This. I'm having the same problem

[@62Akram]

Thank you so much Sir 🎉🎉

[@arunkhanal7208]

Very good tips

[@waleedibrahim4558]

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.

[@tedhead3162]

Love it! ⏮

[@jonny396099]

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]

or F4 to do it with just 1 button :D

[@jonny396099]

@@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!

[@mustafaali7907]

Thanks so much

[@besanty6124]

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

[@maximmaximych]

What clear English!

[@aymanmaraq3218]

wonderful

[@isabellebertino9859]

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

[@hahuynh9777]

Thanks!

[@techteachersandstudents]

Thank you for your generous gift! I'm glad you found my video to be helpful. Thank you.

[@lukaround]

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.

[@pepethepatriot7524]

Agreed, he did it stupid.

[@Chuulip]

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.

[@genesiasheree]

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.

[@MsPoliteRants]

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)

[@user-qm5cb6ov1i]

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?

[@paluri1707]

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

[@johncarpenter6275]

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?

[@tama988]

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

[@sonicclang]

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.

[@zjioudy6397]

collaboration

[@stephendewes4794]

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

[@xxxjamxxx638]

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