auto numbering 1,2,3,...

[Richard]

I tried ctrl drag and got nothing. I could have typed them in by now but I would learn nothing THX!

 

[Frank Kabel]

Hi Richard
not sure what you're trying to achieve or what your issue is. Could you
explain with some more detail?

 

[Jim Rech]

Drag the "fill handle" (the little square in the lower right of the cell
selector). If you don't see it, make sure Tools, Options, Edit, Allow Cell
Drag and Drop is selected.

 

[Gord Dibben]

Richard

Method 1. Enter 1 in A1, 2 in A2 then select both cells drag/copy down using
the fill handle(right-bottom corner of cell).

Method 2. Enter a 1 in A1 then right-click and drag down. Release button and
"Fill Series".

In both cases, be sure you have Tools>Options>Edit "allow cell drag and drop"
checkmarked.

Gord Dibben Excel MVP