Is there a way to group rows that are next to each other separately? For example, can I get seperate groups for rows 6:14, 15:24, 25:34, and 35:44, without having Excel combine them into one single grouping?
I don't want to have insert a blank row between the groups. Here's why...
My worksheet has a header (rows 1:5), and sections below for each quarter. I only want to show the current quarter, and collapse each of the non-current quarters. If I leave a blank cell between each group, the first quarter information shows right under the header, but when I collapse the first quarter and show only the second quarter, the blank row creates a space between the header and the information. The third quarter has two rows between the header and the information, and the fourth quarter has a three row gap between the header and the information. The information is linked into a PowerPoint slide, and I want the spacing between the header and the information to be the same, regardless of which quarter's report is being displayed. It is also used in a printed report, which needs to be consistently formatted each quarter.
Is there a way to accomplish contiguous grouping, or perhaps a better way to do this? Having to manually group and ungroup each quarter feels like it defeats the convenience factor of grouping.
I don't want to have insert a blank row between the groups. Here's why...
My worksheet has a header (rows 1:5), and sections below for each quarter. I only want to show the current quarter, and collapse each of the non-current quarters. If I leave a blank cell between each group, the first quarter information shows right under the header, but when I collapse the first quarter and show only the second quarter, the blank row creates a space between the header and the information. The third quarter has two rows between the header and the information, and the fourth quarter has a three row gap between the header and the information. The information is linked into a PowerPoint slide, and I want the spacing between the header and the information to be the same, regardless of which quarter's report is being displayed. It is also used in a printed report, which needs to be consistently formatted each quarter.
Is there a way to accomplish contiguous grouping, or perhaps a better way to do this? Having to manually group and ungroup each quarter feels like it defeats the convenience factor of grouping.