Excel - Grouping (columns and rows)

Many more great Excel tutorials linked below:

Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques
and many useful and practical ones. Be sure to Subscribe and Comment.

[kathrynfenley]

Very simple and easy.  Thank you for the excellent explanation, step by step, and not talking too fast.  Thank you also for explaining how to ungroup or clear.   Very helpful!   I like how you circled the information in red because often times we cannot see where a person is clicking and have to continuously pause a video to figure it out.  Top notch training  :)

[ashrafosman]

Every time I watch one of your clips, I feel I can use a lot more of excel .. thanks

[rdjalayer]

glad I could be of help, I used a screen-capture software with the inking feature

[xu]

thanks, very helpful and clear. how did you mark or highlight in this video?by using the start inking function under review?

[waynedesilva]

Wow thank you so much. This was so helpful.

[neildew-gosling]

A really helpfully video. Nice pace and clear explanations. Thank you.

[bigboi]

I'm a straight dummy when trying to use Excel. Thank You for this mate.

[ieatmilesforlunch]

Hi im extremely curious, can you link the toggle bar where u clikc 1 2 3 with the actual columns, kind of like instead of clcking on 1 just click directly on the column??? please help

[Stephn]

wow I had no idea David Schwimmer was an ace at Excel

[somysadr]

I need to learn beautiful grouping the same way that it appears in pivot tables. like subtotal categorization

[LAPAM]

loved it ... are you still making videos, I will subcribe

[randomrandy]

So grouping is only used for hiding the rows/columns?

[mauricejohnson]

What shortcut did you use to draw that red circle? The closest I can get is inserting a free form object. Thnx

[janemcmurray]

What video would be best to learn how to make a sheet to include 500 quotations divided by category, name, age, date, that could be extracted and grouped in variety of ways

[ardalanjalayer]

maybe with some VBA buttons you can do such a thing, I have never done this myself though

[lizmuwanga]

But what if I want to use the grouped data within a column in a sense of only grouping for example numbers 1-10 and then 11-20 and then using them as one and calculating a mean for each of these groups in connection to the factor y they will be plotted against? Hope I'm making any sense with this

[pavondaniel]

How can we control where the "plus" button will appear?
When I group lines, for instance, I have some tables where it appears at the left of the header line (one line above the group itself), and others where it appears below the last line of the group, as in your example.
Is there a way to control it?

[torogonzalez]

I have a spreadsheet where Row 1 is the sum of rows 2-10. I want to hide rows 2-10, how do I do that? Thanks for the help.

[ieatmilesforlunch]

can you help me please with my question?

[VijayKumar-ylct]

3 row 1 have one format how convert single row