Auto Fill/Sequential Numbering

[Guest]

Hello,

I am trying to use the autofill feature to drag the letters for sequential
numbering/lettering.

It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for
letters it is just copying.

For instance, I have

A in cell A1
B in cell A2
C in cell A3
and then I want to highlight and drag down so that
D is in A4
E is in A5
F is in A6

Do I need to change an option to get this to work?

Thank you,

 

[Guest]

Highlight cells A1 to A3 and then drag down.

or

Highlight A1, then hold Ctrl and drag down.

Both should work.

 

[JE McGimpsey]

Enter the sequence in Tools/Options/Custom Lists (e.g., A,B,C,...,Z)

 

[Beege]

tjh,

Tools/Options custom lists...

Make one A thru Z, and modify as needed...

Beege

 

[Guest]

Oops ... misread you posting so ignore my crass reply!