Try this:

Put the number 1 in the first cell and leave that cell selected

Then
From the Excel main menu:
<edit<fill<series
Series in: (check Rows or Columns)
Stop Value: (enter the last number of the series)
Click the [OK] button


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Depechez" wrote:

I want to automatically generate a sequence of numbers from 1 to....X without
typing them all. How?