Prev: Display Chosen Autofilter Value
Next: Footer help please
From: sera on 27 Apr 2010 18:33
if anyone has used a list of names in an excel spreadsheet does anyone know
how to alphabetise the names in the spreadsheet?
From: Gord Dibben on 27 Apr 2010 18:54
Data>Sort>Ascending.

Be sure to select all columns you want sorted together before Data>Sort.

Never let Excel guess.


Gord Dibben MS Excel MVP

On Tue, 27 Apr 2010 15:33:01 -0700, sera <sera(a)discussions.microsoft.com>
wrote:

>if anyone has used a list of names in an excel spreadsheet does anyone know
>how to alphabetise the names in the spreadsheet?

From: L. Howard Kittle on 27 Apr 2010 18:58
Select the list and click the Sort Ascending (A to Z) or Sort Decending (Z
to A) in the tool bar.

HTH
Regards,
Howard

"sera" <sera(a)discussions.microsoft.com> wrote in message
news:B12CA209-D079-4AED-983B-4A94A03ACB9B(a)microsoft.com...
> if anyone has used a list of names in an excel spreadsheet does anyone
> know
> how to alphabetise the names in the spreadsheet?


From: bala_vb on 27 Apr 2010 22:51

'sera[_2_ Wrote:
> ;949367']if anyone has used a list of names in an excel spreadsheet does
> anyone know
> how to alphabetise the names in the spreadsheet?



You can sort the names based on either first name or last name by
using, Data->sort->Sort on A-> Z or Z->A

Please let me know how many columns you have, how you want them to be
sorted?

Thanks
Bala




--
bala_vb
 | 
Pages: 1
Prev: Display Chosen Autofilter Value
Next: Footer help please