group cells so they can be sorted together

[Jim A]

Hi -
how do I group rows of cells so that when sorted the info stays together.

Thanks - Jim A

 

[Gord Dibben]

The rows to stay together must have a mutual key identifier in a column
which you sort upon.

Make sure all columns are selected before sorting.

Show us a sample of what you have and what you want.


Gord Dibben MS Excel MVP

 

[Jim A]

Row 1 cells need to stay together in a sort.
Row 2 cells need to stay together in a sort.
etc.
column A are the names that I want to sort by.

Thanks much - Jim Ayers

 

[Bob I]

Select the whole Sheet before you sort, not just the columns.

 

[ebloch]

Insert a range name to include all of your data. Sort that range name on the
column you want.

Eric

 

[Roger Govier]

Hi Rob

I can't see the earlier part of this thread, but if you are not wanting to
see a name repeated on each row, but you need it for sorting to keep all
those rows together, you could use Conditional Formatting on the column to
make the text the same colour as the background.

=$a2=$a1 Format Text White