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

[cmendes]

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
Thanks in advance,
C

 

[mikerickson]

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]

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.

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

 

[Jonmo1]

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

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

 

[mikerickson]

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

=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)

Jonmo1, I like the Substitute approach.

 

[cmendes]

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

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

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]

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]

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

=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1)

Jonmo1, I like the Substitute approach.

Thank you very much! Great time saver!

 

[cafeannalisa]

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]

Welcome to MrExcelforum @cafeannlisa

@Jonmo1's formula works without modification.

@mikerickson's formula would require modification to :-

=LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+(ROW(A1)>702)+1)

hth