Create sequential letters (A, B, C) in sequential cells

**Theale** · 08-29-2012, 02:18 PM

I know how to create sequential NUMBERS - by typing in the first few, highlighting all 3 and then dragging the "X" symbol.
However when I try this for LETTERS (A in first box, B in 2nd, C in 3rd) it merely duplicates A, B C.
How can I get A, B, C, D, E etc?
Probably something really simple, but help appreciated.
(Using Excel 2008 for Mac)

**vandan_tanna** · 08-29-2012, 02:22 PM

may be

A1:= A
A2: =CHAR(CODE(A1)+1)

copy down

**NBVC** · 08-29-2012, 02:31 PM

try:

=SUBSTITUTE(ADDRESS(1,ROWS($A$1:$A1),4),1,"")

copied down.

This will also allow you to get to double A (AA) after Z if that is what you want...

**martindwilson** · 08-29-2012, 02:47 PM

better still open the attached
Click the File tab and then click Options.

The Excel Options dialog box appears.

Click the Advanced tab.

The Advanced options appear in the right pane.

Click the Edit Custom Lists button in the General section.

The Custom Lists dialog box appears.
click in import from cells
select a1:a256
import
you now have a autofil list