Auto Fill/Sequential Numbering

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.

"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,
>
>
>
>
>

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

In article <[email protected]>,
tjh <[email protected]> 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,

tjh,

Tools/Options custom lists...

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

Beege

"tjh" <[email protected]> wrote in message
news:[email protected]...
> 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,
>
>
>
>
>

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

"Toppers" wrote:

> 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,
> >
> >
> >
> >
> >