Many thanks. That solution works
mike (indonesia)

"Pete_UK" wrote:

Do not use the A-Z icons for sorting. Instead, highlight the range you
want to sort (which may or may not include a header row), then click
Data | Sort and choose the sort field(s) and type (ascend/descend)
then click OK. This will keep data on the same rows together.

Hope this helps.

Pete

On Apr 13, 11:12 am, emmcee wrote:
How to sort a column of text alphabetically so that the contents of the
relative rows automatically sort with the column?

The A-Z sort function seems only to work with the individual column.

Any help, gratefully received.

Thanks.