View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default alphabetize entire rows by first word of first column

Hi,

When you do the sort select ALL the columns then in the sort wizard select
the column to sort on (Name) and all the data will stay in their respective
rows
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


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