Alphabetize Letters in Excel 2000

  • Thread starter Thread starter H SELIM
  • Start date Start date
H

H SELIM

Hello!

Using Excel 2000, is there a way to Alphabetize Letters in cells using the
fill handle or another method?

A
B
C
D
etc..

Thank you.

Hal.
 
Roll your own

in A1 put

=CHAR(ROW(65:65))

copy down to A26,while selected do edit>copy, edit>paste special as values
in place, then do tools>options>custom lists,select import and add.
 
Thank you very much for your assistance.

Hal.

Peo Sjoblom said:
Roll your own

in A1 put

=CHAR(ROW(65:65))

copy down to A26,while selected do edit>copy, edit>paste special as values
in place, then do tools>options>custom lists,select import and add.

--

Regards,

Peo Sjoblom
Click to expand...
 
If you would like to use the Fill Handle in this and future Excel sessions,
perhaps add a custom list. This macro will add it for you.

Sub CustomList_Letters()
Application.AddCustomList ListArray:= _
Array("A", "B", "C", "D", "E", "F", "G", "H", _
"I", "J", "K", "L", "M", "N", "O", "P", _
"Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z")
End Sub

HTH.
 
Back
Top