# 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)

[![image.png](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/scaled-1680-/yjsimage.png)](https://bookstack.taylorhome.run/uploads/images/gallery/2023-01/yjsimage.png)