Forum Discussion

SophiesChoice's avatar
SophiesChoice
Copper Contributor
Jan 04, 2022

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!

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    SophiesChoice 

    You need to inform Excel somehow which rows to keep together. It could be one more column, when use multi-level sorting

Resources