View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default multicolumn adress file. want to sort on last , first name

Hi,
Insert and empty row between the titles and the first row with Data, then
highlight the total range from the column containing the Last name to the one
containing the notes, then go to Data Sort and select the column which have
the last name choose Ascending or descending

If this helps please click yes, thanks

"bdcochran" wrote:



"Eduardo" wrote:

Hi,
could you provide an example of your file

"bdcochran" wrote:

how do i do it.

Last First Telephone Address Suite City State Zip CodePersonal Notes