View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default alphabetize entire rows by first word of first column

Just make sure you select ALL the columns containing info before sorting.

Cindy Sue wrote:

I want to make a list of names and addresses putting name, address, city,
state, zip across in separate columns. Is there a way to attach these so
that when I alphabetize the names each of the cells in the row stay with the
correct person?