View Single Post
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

Create a "Custom List" and you'll be able to autofill it.

For some reason, Redmond chose not to include the alphabet in the default
custom lists file, but you can easily do it yourself.

Key in the alphabet down a column.
Case doesn't matter, since XL will duplicate the autofill in whatever case
you initiated the sequence.

Select the range containing the letters, and then:

<Tools <Options <CustomLists,
And since the cells were selected, the address of the range is automatically
entered in the import window, so just click <Import <OK.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Maxwell" wrote in message
...
please how can I generate A B C to Z serially and automatically in Excel
workbook?