How can I fill in a column with the alphabet

[Vincent]

I know there is a way that I can type in a in cell a1,b cell a2, b , cell a3,
c and then drag to the bottom of the column and it will continue with d,
e,f, etc but have forgotten.Can somebody please remind me again.
Thanks

[barrfly]

Tools - Options - Custom Lists.

Should be easy from there...

[David McRitchie]

Hi Vincent,
Use of the fill handle
http://www.mvps.org/dmcritchie/excel/fillhand.htm

I think you will also have to make up a custom list also
described on the page.
A, B, C, ...., X, Y, Z, a, b, c, d, ... , x, y, z .

try filling down if it doesn't work you will need th custom list.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Vincent" <[email protected]> wrote in message news:[email protected]...
> I know there is a way that I can type in a in cell a1,b cell a2, b , cell a3,
> c and then drag to the bottom of the column and it will continue with d,
> e,f, etc but have forgotten.Can somebody please remind me again.
> Thanks