View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default sorting excel worksheet

select all of the cells you want to sort together
either use data-sort
or
use the tab button to go to the column you want to sort by and use the A-Z
button

"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.