Create a numerical sequence in a column: From 1 to ....

[Depechez]

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

[Bondi]

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

Hi Depechez,

You could type in 1 in A1 and 2 in A2.
Then highlight them and pull the autofill handle (The little black
square in the buttom right cornor of your highligted selection) to the
row you want to.

Regards,
Bondi

[Gord Dibben]

In A1 enter 1

In A2 enter 2

Select both cells and drag/copy down column A as far as you wish.

OR

Enter 1 in A1

In name box enter A1:A12300 and ENTER

Edit>Fill>Series>OK


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 08:59:02 -0700, Depechez
<[email protected]> wrote:

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

[Ron Coderre]

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?