auto numbering 1,2,3,...

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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.

--
Jim Rech
Excel MVP
"Richard" wrote in message
...
|I tried ctrl drag and got nothing. I could have typed them in by now but I
would learn nothing THX!

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 ToolsOptionsEdit "allow cell drag and drop"
checkmarked.

Gord Dibben Excel MVP

On Tue, 27 Apr 2004 21:16:03 -0700, "Richard"
wrote:

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