Excel Autofill Letters from A to Z
This formula tip will let you fill a column with the letters A to Z.
Start by putting the letter A in a cell. I put the letter A in the cell A1 for the example below. Then in cell A2 I inserted the formula. Note I reference the cell A1. Then I simply copied the formula down to the A26 cel and viola I have the alphabet automagically.
=CHAR(CODE(A1)+1)