When you’re working with outlines, there are a few things to keep in mind.
First, when you have some of your groups minimized, and you select the visible rows, you’re actually selecting the invisible rows as well, just like when you hide rows the traditional way.
To select only the visible rows (if you want to copy and paste them, for example), you’ll need to go about it differently.
Once you’ve minimized the groups you don’t want to copy, head to the Home tab. From there, click the Find & Select button, and choose Go To Special:
You can also use groups and outlines to create graphs and charts of specific subsets of data.
As a quick example, take a look at this chart that includes all the data in our spreadsheet:
If we minimize most of the groups and create the same chart, however, we get a smaller one: