Auto fill letters in Excel 2010

Question

I want to make a list with the letters A...Z. Is it possible to do that with the auto fill feature through drag&drop or auto fill through the menu? For example if I use A, B, C as a "starting list". I tried various combination of selecting A-C and "dragging" and using the auto fill feature, but nothing worked (I got results like A,B,C,A,B,C...). Something I forgot to get the desired result? (If possible without manually adding an custom list).

From here (for example):

Column A
  A
  B
  C

and I want to get to this:

Column A
  A
  B
  C
  D
  E
  F
  G
  [...]
  Z

Please note: I want to have values inside the cells, not formulas.

Start typing A, B, then C in your column. Then select all three of those values and "grab" the bottom right corner of the selection box (it's a slightly larger square). Just drag the selector down as many rows as you want. There will be a little pop-up indicator of the last value that would be added if you release at that point. — PeterT, Jul 23 '18 at 00:03
yeah I tired that already, that only works for numbers (without creating a custom list) thanks for the hint though, I added it to my question. — Albin, Jul 23 '18 at 00:42

score 1 · Accepted Answer · edited Jul 23 '18 at 16:23

1

You can calculate the letter manually via a formula:

In the first cell (for example B2) enter "A"
In the next cell (i.e. B3) use =CHAR(CODE(B2) + 1)
Drag the cell B3 down until you get Z

To change the formulas to "real" values:

Select the whole list (A through Z)
Copy it into the clipboard
Use "paste content" with values only and "paste" it onto the same position

edited Jul 23 '18 at 16:23

Albin

9,307
11
50
89

answered Jul 23 '18 at 01:07

phuclv

26,555
15
113
235

I looked around a lot, but I didn't find any better solution, so for now I will mark this as the answer... but anyone with a "easier" answer (if you think it's easier) please feel free to suggest another solution! – Albin Jul 23 '18 at 16:15

score 0 · Answer 2 · edited Jul 23 '18 at 07:01

0

You need to type all letters manually on a sheet and follow the below step

Go to File
Click on Option
Click on Excel Option
Click on Advance
Go to Edit Custom List
Import all Letters that you have already created on a sheet.
Click OK then again OK.
Write A and drag the cell using fill handle.

edited Jul 23 '18 at 07:01

phuclv

26,555
15
113
235

answered Jul 23 '18 at 06:07

Stuart

7
2

score 0 · Answer 3 · answered Jan 12 '21 at 10:16

0

In newer Excel you have an alternative way: =CHAR(SEQUENCE(26,1,65)). This formula will generate an array of character values like this

answered Jan 12 '21 at 10:16

phuclv

26,555
15
113
235

Auto fill letters in Excel 2010

3 Answers3