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.

Answer 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

Answer 2

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

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

Answer 3

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