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

cmendes

Board Regular
Joined
Jan 24, 2011
Messages
66
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
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
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.
 
Upvote 0
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
 
Upvote 0
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,"")
 
Upvote 0
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.
 
Upvote 0
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. :cool:
 
Upvote 0
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, ....
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top