J
Jim A
Hi -
how do I group rows of cells so that when sorted the info stays together.
Thanks - Jim A
how do I group rows of cells so that when sorted the info stays together.
Thanks - Jim A
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
J
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
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
B
Bob I
Select the whole Sheet before you sort, not just the columns.
E
ebloch
Insert a range name to include all of your data. Sort that range name on the
column you want.
Eric
column you want.
Eric
R
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
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