Grouping Cells

[ritameneses]

I need to sort a file that has multipule "rows" that belong together, so if I sort by column A, the rows do not stay together as needed. Is there any way to tell Excel that a group of cells are to be treated at 1 cell or sorting purposes? Thanks in advance for any help.

 

[dantb]

You have to pick the range of data to be sorted

 

[PaddyD]

hi - welcome to the board

"Is there any way to tell Excel that a group of cells are to be treated at 1 cell or sorting purposes?"

By adding an extra column with the grouping class info & sorting on that first

 

[DCasper]

Paddyd

did you have any luck with this?

 

[PaddyD]

I wasn't seeking help so wasn't in need of luck - what are you after?