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)