Excel Group & Outline Buttons | Easiest way to Hide & Unhide Rows & Columns

0:00 Introduction
0:23 Manually Group Rows and Columns
2:34 Automatically Group Rows
3:18 Automatic Subtotals
5:00 Tips for working with Grouped Data
5:38 Hiding Group and Outline buttons

[olivierissaverdens]

Thank you Mynda for this very clear explanation! I would just add that it is possible to choose to have the "+" or "-" signs at the top or at the bottom of the grouped lines as well as on the left or on the right of the grouped columns by clicking on the little arrow of the Outline box of the ribbon.

[UghUgh]

Love the beginner excel tips just as much as the complicated ones! Excel is so large, even the most savvy excel users can miss the most simplest functions!

[wayneedmondson]

Hi Mynda. Great tips! I group and ungroup data frequently and so use the keyboard shortcuts: SHIFT+ALT+RIGHT ARROW (to group) and LEFT ARROW (to ungroup). Saves a little time if you do it often. Thanks for the tips! Thumbs up!!

[andrewerlewein]

Thank you for the video, all of your videos are valuable. That being said In my personal day-to-day workflow when I am sent a sheet with groups the first thing I do is remove them and never look back.

[qudsia]

Thank you! Other than the useful info, really liked the calm, non-dramatized, style of presentation that's becoming a rarity on YouTube 💚

[vijayarjunwadkar]

Very useful video as usual! Thanks Mynda! While I knew this feature, I did learn new things about them! 😊👍

[pvrameshbabu]

thanks Mynda nice crisp explanation of group, ungroup and subtotal features.

[haithamfathy]

You are the best in explaining the Excel option,

[hopp.nguyen]

that is the solution I'm looking for, thank you

[patrick.schommer]

One additional not-so-obvious tip is clicking on the little call-out symbol in the lower right corner of the Outline group that contains the Group/Ungroup/Subtotal ribbon buttons. It allows you to position the outline symbols below or to the right of the grouped data if that is your preference. (I see another user already shared this same tip. See how popular it is!)

[lchase]

Thanks Mynda, your explanations and tips are always on point.
😉

[GeertDelmulle]

Like almost everybody else I’ve been using grouping like forever — can indeed be useful.
But they also have drawbacks: e.g. when you remove/add a row/column the grouping gets messed up.
And still, most of us keep using them. :-)

[minawater]

Thank you !!!! makes my excel more neat

[JT-qwcr]

Excellent, thank you! Is it possible to move about the different sections as you would do in Word Outlines? I don't think so, but its always better to check with the experts!

[Everyonelovesyou]

Was looking for the same on today. It really helped

[darrylmorgan]

Hi Mynda!Really Helpful Tutorial...Thank You :)

[JaniceCook-jxpw]

Thanks - I want my users to close and expand the groups so that they can drill down, or review each section of data one at a time - however I also need to protect to sheet to protect the data/formulas but this seems to disallow the group open and close - how can I allow the open and close, but protect the sheet?

[leoceoliveira]

I love this feature. Is there a way to show the level number buttons when hiding the headings?

[moxie]

Ctrl+8 - this is a shortcut to show/hide the group buttons. Avoids having to visit the options menu

[GaryMason-yr]

I'm looking for a way to group individual columns but have the ability to open/close them at the same time. For example, columns A, C, E, G Id like to group or have a way to make them visible or hide with one touch of a button. Is it possible?