For additional help with sorting see
http://www.mvps.org/dmcritchie/excel/sorting.htm
but as already pointed out to you the important thing
is to select the area to be included in the sort, and do
not ever rely of the automatic expansion of a single
cell to expand to the current region (Ctrl+SHIFT+*) to
actually define the range you want to work with as you
will surely destroy you data sooner or later.

If you have Excel 2003 or later you cannot rely on Ctrl+A
to select all of the cells either, so again you risk destroying
your data. If you do have Excel 2003 or later see
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar

In using the A-Z sort you might want to insure that the title
will sort before the rest of column, as Excel's determination
of whether there is a header row involved is very poor, so
be aware of what you have and be ready to use Ctrl+Z if
the sort does not work. Ctrl+Z will not work if you have
used a macro or have an Event macro in place for the worksheet.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"emmcee" wrote in message ...
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.