Filtering In Excel

[andy-hughes]

I am trying to group together sections of an excel sheet.

I have clicked on the Edit, and selected the label I want to filter, but all it does is add the label to everything on the sheet.

Can someone explain what I am doing wrong please? Or point me at a tutorial?

Thanks.

[Zacs-Master]

Are you using the ‘funnel’ button to apply a filter?

[andy-hughes]

Yes - unless you know different?

[Zacs-Master]

I think you’ll have to highlight the cells you want to group and then apply the filter.

[Buenchico]

I usually hate it when people answer with "Why don't you google it?", or similar, as it seems particularly unhelpful. However, if the links below don't help, I suggest searching Youtube for 'group sections excel'. There seem to be plenty of videos on the subject but I can't identify any particular one as being the best for you.

Here's Microsoft's own page on the subject:
https://support.office.com/en-us/article/outline-group-data-in-a-worksheet-08ce98c4-0063-4d42-8ac7-8278c49e9aff

Here's WikiHow (which is often a decent source of information):
https://www.wikihow.com/Group-and-Outline-Excel-Data

. . . and here's HelpDeskGeek (which I also like):
https://helpdeskgeek.com/office-tips/group-rows-and-columns-in-an-excel-worksheet/

[andy-hughes]

Thanks all.

[fiction-factory]

I think Andy is past that stage. It may be useful to someone though, although I would advise against clicking on your link..
I think the cut and paste has been through Google translate several times:
"A Chart is a ground-breaking apparatus that allows you to outwardly show data information in a wide range of outline organizations...."