Prev: Downward column
Next: Pivot Table - Calculated Field
From: Jannoth on 24 Mar 2010 08:38
In previous versions of Excel, if I added A,B,C,D,E to the first few rows of
a column then dragged the AutoFill handle downwards, Excel would have
recognised a pattern and suggested the remaining values for me.

In 2007, if recognises the values but suggestions simply start from A again,
so I'd get A,B,C,D,E,F,A,B,C etc. Not what I want.

Can someone please suggest what I'm doing wrong - as this used to be a great
feature which saved me hours of time.

Thanks

J
From: Mike H on 24 Mar 2010 08:58
Hi,

Office Button|Excel Options|Popular - Edit custom lists

Create a custom list of the letters of the alphabet
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jannoth" wrote:

> In previous versions of Excel, if I added A,B,C,D,E to the first few rows of
> a column then dragged the AutoFill handle downwards, Excel would have
> recognised a pattern and suggested the remaining values for me.
>
> In 2007, if recognises the values but suggestions simply start from A again,
> so I'd get A,B,C,D,E,F,A,B,C etc. Not what I want.
>
> Can someone please suggest what I'm doing wrong - as this used to be a great
> feature which saved me hours of time.
>
> Thanks
>
> J
From: Luke M on 24 Mar 2010 09:29
This is untrue for previous versions. XL can only autocomplete alpha lists
that have been stored in its group of lists (such as months and days).

--
Best Regards,

Luke M
"Jannoth" <Jannoth(a)discussions.microsoft.com> wrote in message
news:1D53E3D6-1A24-48D4-92DE-2E80D667F3A9(a)microsoft.com...
> In previous versions of Excel, if I added A,B,C,D,E to the first few rows
> of
> a column then dragged the AutoFill handle downwards, Excel would have
> recognised a pattern and suggested the remaining values for me.
>
> In 2007, if recognises the values but suggestions simply start from A
> again,
> so I'd get A,B,C,D,E,F,A,B,C etc. Not what I want.
>
> Can someone please suggest what I'm doing wrong - as this used to be a
> great
> feature which saved me hours of time.
>
> Thanks
>
> J


From: Ashish Mathur on 25 Mar 2010 00:14
Hi,

Let's say you want the series to start from cell A4. In cell A4, enter
=CHAR(ROW()+61) and copy down

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Jannoth" <Jannoth(a)discussions.microsoft.com> wrote in message
news:1D53E3D6-1A24-48D4-92DE-2E80D667F3A9(a)microsoft.com...
> In previous versions of Excel, if I added A,B,C,D,E to the first few rows
> of
> a column then dragged the AutoFill handle downwards, Excel would have
> recognised a pattern and suggested the remaining values for me.
>
> In 2007, if recognises the values but suggestions simply start from A
> again,
> so I'd get A,B,C,D,E,F,A,B,C etc. Not what I want.
>
> Can someone please suggest what I'm doing wrong - as this used to be a
> great
> feature which saved me hours of time.
>
> Thanks
>
> J

From: Gord Dibben on 25 Mar 2010 14:24
See other replies for creating custom lists.

Note lists are case-sensitive

you must create two lists

one with upper case A,B,C

one with lower case a,b,c


Gord Dibben MS Excel MVP

On Wed, 24 Mar 2010 05:38:01 -0700, Jannoth
<Jannoth(a)discussions.microsoft.com> wrote:

>In previous versions of Excel, if I added A,B,C,D,E to the first few rows of
>a column then dragged the AutoFill handle downwards, Excel would have
>recognised a pattern and suggested the remaining values for me.
>
>In 2007, if recognises the values but suggestions simply start from A again,
>so I'd get A,B,C,D,E,F,A,B,C etc. Not what I want.
>
>Can someone please suggest what I'm doing wrong - as this used to be a great
>feature which saved me hours of time.
>
>Thanks
>
>J

 | 
Pages: 1
Prev: Downward column
Next: Pivot Table - Calculated Field