Hey guys,

How do I select all the data within a single group on excel?
See the attached photo below regarding this question. The best way I have of describing what I mean is if I show you some examples:


Example 1 (see photo):
If row167 is highlighted. Is there a quick way to highlight 167 to 212? (Shift + down gives 167 to 213. I do not want to include 213.)

Example 2:
If row1030 is highlighted/currently selected. Is there a quick way to highlight 1030 to 1035 (shift + down gives 1030 to 1036. I do not want to include 1036 in this example.)

Example 3:
or 577 to 643, etc


All the data is continuous; if I expand to group level 3, and Ctrl+Down, the selection goes to Row 1174.


Thanks guys,
Jimmy
Groups.png