You can group your data in Excel by using outlines. An outline allows you to group and limit that data that you are viewing You have two types - Auto and Manual. Auto Outline works well if you have used Summaries (formulas to tally rows). Manual works well if you just have a list and you wish to choose the groups.
To add an outline to your data: