I simply want to continue the series numbers 1,2,3,€¦ (autocount) without
holding down the mouse €˜fill handle. Some databases are so extensive
(40,000+ records) that it would require a complete minute or more to produce
the series.

Thanks.

Microsoft help did not work.

Enter your starting number in the first cell. Highlight that cell. Then,
depending which version of Excel you have...

In Excel 2003 or older:
From the EDIT Menu, choose "Fill" then "Series..."
Change "Series In" to "Columns"
Enter your "Stop Value" (40000)
Click OK

In Excel 2007:
From the HOME Tab, go to the "Editing" section
Click on the "Fill" button (Looks like a Down Arrow)
Select "Series"
Change "Series In" to "Columns"
Enter your "Stop Value" (40000)
Click OK

HTH
Elkar


"Antonio" wrote:

I simply want to continue the series numbers 1,2,3,€¦ (autocount) without
holding down the mouse €˜fill handle. Some databases are so extensive
(40,000+ records) that it would require a complete minute or more to produce
the series.

Thanks.

Microsoft help did not work.

Hi Antonio,

Try this.


Enter 1 in A1 .

Under Edit select Fill Series in Columns Step value = 1 Stop value
40000 OK

HTH
Regards,
Howard

"Antonio" wrote in message
...
I simply want to continue the series numbers 1,2,3,. (autocount) without
holding down the mouse 'fill handle'. Some databases are so extensive
(40,000+ records) that it would require a complete minute or more to
produce
the series.

Thanks.

Microsoft help did not work.