•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Adjacent rows forming one group instead of separate groups
Our take
When grouping rows of data in a spreadsheet, it's essential to understand how adjacent rows can impact the grouping process. In your case, it sounds like you're encountering an issue where adjacent rows merge into a single group instead of forming separate ones. This can indeed be confusing, especially when guidance suggests otherwise. It’s crucial to ensure that you’re correctly selecting the intended rows and considering any hidden factors that may affect the grouping.
I'm trying to group rows of data, sometimes there is a single row that doesn't need to be grouped. When there is a row break between the groups they form normally. But when the rows of data are adjacent they merge into one group instead of separate groups, even tho googling indicates it should make separate groups. I've tried selecting the whole rows and just the cells but neither works What am I doing wrong?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience