how to use Excel to generate alphabet serially
 

please how can I generate A B C to Z serially and automatically in Excel
workbook?

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?

Another way to try ..

Filling A - Z down
-------------
Put in any starting cell:
=CHAR(ROWS($A$1:A1)+64)
Copy down 26 rows

Filling A - Z across
-------------
Put in any starting cell:
=CHAR(COLUMNS($A$1:A1)+64)
Copy across 26 cols

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Maxwell" wrote in message
...
please how can I generate A B C to Z serially and automatically in Excel
workbook?

=CHAR(ROWS($A$1:A1)+64)
=CHAR(COLUMNS($A$1:A1)+64)

If you want the fill in lower case: a - z
just change the "64" to "96" in the formulas above

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Max -

Just a little shorter version of each
=CHAR(ROW(A1)+64)
=CHAR(COLUMN(A1)+64)


"Max" wrote in message
...
Another way to try ..

Filling A - Z down
-------------
Put in any starting cell:
=CHAR(ROWS($A$1:A1)+64)
Copy down 26 rows

Filling A - Z across
-------------
Put in any starting cell:
=CHAR(COLUMNS($A$1:A1)+64)
Copy across 26 cols

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Maxwell" wrote in message
...
please how can I generate A B C to Z serially and automatically in Excel
workbook?

Duke, thanks. The slightly longer versions were to make it a little more
robust, in case new rows / columns are inserted above / left of the starting
cell subsequently. It's something I picked up here along the way, which has
since got a little "stuck-on" as a personal practice, I guess <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Duke Carey" <duke_No_Junk_carey_at_hotmail.com wrote in message
...
Max -

Just a little shorter version of each
=CHAR(ROW(A1)+64)
=CHAR(COLUMN(A1)+64)

BTW - FWIW,

None of these formula solutions will *automatically* work (be imported) into
Custom Lists.
You have to clear the formulas from the cells before XL will accept them
into a list.

Now, the OP asked for A ... Z

I think keying in 26 letters down a column *AIN'T* really that difficult.

What do you think?<bg
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Max" wrote in message
...
Duke, thanks. The slightly longer versions were to make it a little more
robust, in case new rows / columns are inserted above / left of the starting
cell subsequently. It's something I picked up here along the way, which has
since got a little "stuck-on" as a personal practice, I guess <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Duke Carey" <duke_No_Junk_carey_at_hotmail.com wrote in message
...
Max -

Just a little shorter version of each
=CHAR(ROW(A1)+64)
=CHAR(COLUMN(A1)+64)

"RagDyeR" wrote
... keying in 26 letters down a column *AIN'T* really that difficult.
What do you think?<bg

Agreed <g , albeit it'll take me all of between 30 - 45 secs to get it down
right
(gotta hunt for the durned alphas on the keyboard, they're scattered all
over the place !)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

For the alphabet challenged <g:

Turn on Caps Lock
Type a Q, press Enter
Continue across the keyboard, to type all the letters in a column
Select a cell in the list, and click the A-Z button on the Excel toolbar


Max wrote:
"RagDyeR" wrote

... keying in 26 letters down a column *AIN'T* really that difficult.
What do you think?<bg


Agreed <g , albeit it'll take me all of between 30 - 45 secs to get it down
right
(gotta hunt for the durned alphas on the keyboard, they're scattered all
over the place !)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Aha ... That *did* help bring it down
to slightly under 30 secs flat, all-in, Debra! <bg
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

But guys like me remove those darned icons from every machine in the plant.

They cause more trouble then they're worth.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Debra Dalgleish" wrote in message
...
For the alphabet challenged <g:

Turn on Caps Lock
Type a Q, press Enter
Continue across the keyboard, to type all the letters in a column
Select a cell in the list, and click the A-Z button on the Excel toolbar


Max wrote:
"RagDyeR" wrote

... keying in 26 letters down a column *AIN'T* really that difficult.
What do you think?<bg


Agreed <g , albeit it'll take me all of between 30 - 45 secs to get it
down
right
(gotta hunt for the durned alphas on the keyboard, they're scattered all
over the place !)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html