View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default 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