# Autofill A B C D...AA AB...

#### cmendes

##### Board Regular
Hello,

I remember that excel could complete a sequence is we gave it the first elements.
In this case I'm writing in three different cells (same column) A, B C and I want excel to do the rest as I drag it down: D E F and so on. But if do it I get A B C again...
Is there anything that i have to do??
I'm using Excel for mac 2011
C

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### mikerickson

##### MrExcel MVP
According to Help, you can continue a series of numbers, text-and-number combinations (e.g. Item1, Item2, ...) or formulas.
Sequential letters is not in that list. (What comes after Z, AA or [ ?)

You could put =CHAR(64+ROW(A1)) in the "A" cell and drag down, then copy paste values.

#### cmendes

##### Board Regular
According to Help, you can continue a series of numbers, text-and-number combinations (e.g. Item1, Item2, ...) or formulas.
Sequential letters is not in that list. (What comes after Z, AA or [ ?)

You could put =CHAR(64+ROW(A1)) in the "A" cell and drag down, then copy paste values.

It does work!! Although after the Z comes '['...and not AA but it's ok

#### Jonmo1

##### MrExcel MVP
My Questions is...
Why do you want this?
Are you planning on using these in a formula to reference Cells later on?

There are easier ways, can you explain your larger goal?

But anyway, try this

#### mikerickson

##### MrExcel MVP

If you want A, B, C, ..., Y, Z, AA, AB, ... you could use the formula

Jonmo1, I like the Substitute approach.

Pdj

#### cmendes

##### Board Regular
My Questions is...
Why do you want this?
Are you planning on using these in a formula to reference Cells later on?

There are easier ways, can you explain your larger goal?

But anyway, try this

I have an excel sheet with more than 70 parameters, each in a column.
I want to have a reference (or index) so that I can print out where each parameter is. What I did was to copy the legends from each column, paste (transpose) and next to each parameter have a Letter. Now i can print and know where each thing is.

#### Jonmo1

##### MrExcel MVP

I have an excel sheet with more than 70 parameters, each in a column.
I want to have a reference (or index) so that I can print out where each parameter is. What I did was to copy the legends from each column, paste (transpose) and next to each parameter have a Letter. Now i can print and know where each thing is.

OK, just for display purposes.

#### Ekkehard

##### New Member
If you want A, B, C, ..., Y, Z, AA, AB, ... you could use the formula

Jonmo1, I like the Substitute approach.

Thank you very much! Great time saver!

#### cafeannalisa

##### New Member
Also found this of great help. But I have many more than columns than 702 (ZZ) so I wonder if the formulas could be extend to include AAA, ....

#### ukmikeb

##### Well-known Member
Welcome to MrExcelforum @cafeannlisa

@Jonmo1's formula works without modification.

@mikerickson's formula would require modification to :-
Code:
``=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+(ROW(A1)>702)+1)``

hth

Last edited:

Replies
6
Views
89
Replies
6
Views
111
Replies
0
Views
42
Replies
4
Views
152
Replies
8
Views
73