You must let Excel know in some way what you want and how far to extend when
you enter the first item of a list into a cell.

Dragging is one way to fill across or down.

Another is....................

Enter the letter "a" in A1

Type A1:A26 or A1:Z1 in NameBox and hit Enter

EditFillAutoFill


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 07:57:01 -0800, ManhattanRebel
wrote:

I have a custom list stored in Auto Fill. Rather than click and drag auto
fill through all the colums in the list, is there any way I can make list
populate without having to drag my cursor through all the columns?