Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Autocomplete Alpha List
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Autocomplete Alpha List
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Autocomplete Alpha List
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Autocomplete Alpha List
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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Autocomplete Alpha List
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autocomplete in dropdown list in Excel as I begin typing | Excel Worksheet Functions | |||
1 column alpha list in excel to print to 2 columns | Excel Worksheet Functions | |||
excel 2002 question for pick from list with autocomplete function | Excel Worksheet Functions | |||
autocomplete from specific list | Excel Worksheet Functions | |||
Alpha sort excel mail list | Excel Discussion (Misc queries) |