Hi Baba

don't sort A to Z in a column :) - if you just select a column and use the
A to Z icon, excel will only sort that column.

IMHO the best way to sort data in excel is either select all your data not
just a column or select only one cell then use Data / Sort from the menu -
nominate the column to sort by and then your data should always stay
together.

Cheers
JulieD

"Baba" wrote in message
...
When I sort A to Z in a column, the rows don't stay together. Names and
addresses are all mixed up.