software

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,
Highlight cells A1 to A3 and then drag down.

or

Highlight A1, then hold Ctrl and drag down.

Both should work.

quot;tjhquot; wrote:

gt; Hello,
gt;
gt; I am trying to use the autofill feature to drag the letters for sequential
gt; numbering/lettering.
gt;
gt; It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for
gt; letters it is just copying.
gt;
gt; For instance, I have
gt;
gt; A in cell A1
gt; B in cell A2
gt; C in cell A3
gt; and then I want to highlight and drag down so that
gt; D is in A4
gt; E is in A5
gt; F is in A6
gt;
gt; Do I need to change an option to get this to work?
gt;
gt; Thank you,
gt;
gt;
gt;
gt;
gt;

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

In article gt;,
tjh gt; wrote:

gt; Hello,
gt;
gt; I am trying to use the autofill feature to drag the letters for sequential
gt; numbering/lettering.
gt;
gt; It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for
gt; letters it is just copying.
gt;
gt; For instance, I have
gt;
gt; A in cell A1
gt; B in cell A2
gt; C in cell A3
gt; and then I want to highlight and drag down so that
gt; D is in A4
gt; E is in A5
gt; F is in A6
gt;
gt; Do I need to change an option to get this to work?
gt;
gt; Thank you,

tjh,

Tools/Options custom lists...

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

Beege

quot;tjhquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I am trying to use the autofill feature to drag the letters for sequential
gt; numbering/lettering.
gt;
gt; It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for
gt; letters it is just copying.
gt;
gt; For instance, I have
gt;
gt; A in cell A1
gt; B in cell A2
gt; C in cell A3
gt; and then I want to highlight and drag down so that
gt; D is in A4
gt; E is in A5
gt; F is in A6
gt;
gt; Do I need to change an option to get this to work?
gt;
gt; Thank you,
gt;
gt;
gt;
gt;
gt;
Oops ... misread you posting so ignore my crass reply!

quot;Toppersquot; wrote:

gt; Highlight cells A1 to A3 and then drag down.
gt;
gt; or
gt;
gt; Highlight A1, then hold Ctrl and drag down.
gt;
gt; Both should work.
gt;
gt; quot;tjhquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I am trying to use the autofill feature to drag the letters for sequential
gt; gt; numbering/lettering.
gt; gt;
gt; gt; It works for numbers 1, 2 ,3 then automatically drags in 4, 5, 6. But for
gt; gt; letters it is just copying.
gt; gt;
gt; gt; For instance, I have
gt; gt;
gt; gt; A in cell A1
gt; gt; B in cell A2
gt; gt; C in cell A3
gt; gt; and then I want to highlight and drag down so that
gt; gt; D is in A4
gt; gt; E is in A5
gt; gt; F is in A6
gt; gt;
gt; gt; Do I need to change an option to get this to work?
gt; gt;
gt; gt; Thank you,
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;