View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default Auto Fill/Sequential Numbering

Highlight cells A1 to A3 and then drag down.

or

Highlight A1, then hold Ctrl and drag down.

Both should work.

"tjh" wrote:

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,