How to Drag and Autofill Alphabet to Get AA, AB, AC Values in Excel

How to Drag and Autofill Alphabet to Get AA, AB, AC Values in Excel
But once you cross Z it will start again from A but in this tutorial, we are going on a different approach. Here once we drag and autofill A to Z and if we keep dragging it will start from AA and then AB, AC and so on.
Now without further ado lets learn how to create Alphabet series in excel like AA, AB, AC in Excel
Step 2: Click on “Visual Basic” Then “Insert” and select “Module”
Step 4: Now Save the workbook in .xlsm format
Step 5: Now write the below function in Row 1
=AlphabetSeries(ROW())
Done. Now if you drag using the fill handle, you’ll be able to get the desired alphabet series in your workbook. Now if you want to start the sequence from row 3 for example then you’ll have to use this formula instead.
=AlphabetSeries(ROW()-2)
Here, the trick is simple. If you start from row 3 then you’ll have to add -2 in the formula. If your starting row number is 10 then you’ll have to add -9. Like Below:
=AlphabetSeries(ROW()-9)
This is how you autofill alphabet series in excel to get AA, AB, AC and so on.

#Autofill #FillHandle #Alphabet

Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[lonniestewart]

How would the code look if you wanted to exclude certain alpha characters like "I", "O" or "Q" etc... from your function output?

[MrMulrine]

easier to enter A in cell A1 and then in B1 type =SUBSTITUTE(ADDRESS(1, ROWS(A$1:A1), 4), 1, "") and drag down

[navalsharma]

Please share excel sheet of above formula, ready made

[Gert-JanLeutscher]

Whenever i try this i get a value error. Any suggestion?