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?