Forum Discussion
SophiesChoice
Jan 04, 2022Copper Contributor
Create sub rows
Dear all,
I have a quite simple Excel sheet with coloms and rows. I have added sorting buttons on top of the coloms.
The problem is that when sorting, excel sorts every row apart. But I have multiple rows which belong together. How can I make sure this lines/rows always stay together when sorting?
Thanks!
I have a quite simple Excel sheet with coloms and rows. I have added sorting buttons on top of the coloms.
The problem is that when sorting, excel sorts every row apart. But I have multiple rows which belong together. How can I make sure this lines/rows always stay together when sorting?
Thanks!
1 Reply
- SergeiBaklanDiamond Contributor
You need to inform Excel somehow which rows to keep together. It could be one more column, when use multi-level sorting