View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default How do I format a column in alpha order?

I presume you mean sort a column into alpha order.
Do you want the other columns on the same row to travel with the sort or
stay in place. Normally you want everything to stay together so
you would select all cells before invoking the sort.

If you want to restrict you sort to one column only then you would select
the one column only before invoking the sort.

More information on sorting in
http://www.mvps.org/dmcritchie/excel/sorting.htm

and on these pages (these are index pages)
http://www.contextures.com/tiptech.html an index page
http://www.datapigtechnologies.com/ExcelMain.htm flash video tutorials


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marian" wrote in message ...