Google Sheets: How to group adjacent columns without merging the groups?

Ask Anything
,
1

As the title puts it, how does one create groups that are adjacent to each other? Much like the one that exists in the “Paycheck Deduction Transaction Generator” workflow for example (seen here: https://i.imgur.com/hWoqlXq.png)?

Thanks!

2

Select columns and choose ‘Group’ from the ‘View’ menu.

3

Thanks for the quick answer @jpfieber but unfortunately for me that “obvious path” doesn’t work when they’re adjacent (as it auto merges groups).

Here are two GIF’s of it in action (using the “view” menu, and the right click one)

4

Ahh, you have to leave a blank column between them, which ends up falling below the ‘+’ so that’s where I put the labels for each group. In your top example, leave W blank for the label, and group T/U/V instead of U/V/W.

2 Likes