Autofill a b c d aa ab in Excel
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,
Answer:
Use the formula =SUBSTITUTE(ADDRESS(1,ROWS(A$1:A1),4),1,"")
(for formulas, depending on your country, you might have to change ; with ,
or the opposite
You can find similar Excel Questions and Answer hereunder
1) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?
2) How to disable ability to insert Rows and Columns in Excel (using VBA)?
3) How to find the cell address from the column number in VBA
4) How to find the column number from the cell address in VBA
5) Is there a way I can round the sales figure to the nearest 500?
6) I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?
7) How to hide and unhide rows and columns in Excel
8) How to freeze a row or column in Excel
9) How can I convert Column numbers into Column names for use in range definition?
10) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?