how do i make a list ie 1 to 100

just forgot how to do it can some one plz help thanx

ie
1
2
3
4
5
6
ect all the way to 100

Enter 1 in A1, 2 in A2.
Select A1:A2
Go to the bottom right of the selection until the cursor changes to a black
+
Click and drag down to A100


--
HTH

-------

Bob Phillips
"pip" <pip@discussions.microsoft.com> wrote in message
news:5CA0F67B-372C-495C-A198-385781418BCF@microsoft.com...
> just forgot how to do it can some one plz help thanx
>
> ie
> 1
> 2
> 3
> 4
> 5
> 6
> ect all the way to 100

Several ways to do this.

1. Enter a 1 in row 1. Right-click on bottom right corner of cell and drag
down to row 100. Release right button and select "Fill Series"

2. Enter a 1 in row 1. Edit>Fill>Series>Linear>Step=1 Stop=100

3. Enter a 1 in row 1 cell, a 2 in next cell down. Left-click and drag down
to row 100.

4. In row 1 enter =Row(). Drag>copy down to row 100.


Gord Dibben Excel MVP

On Wed, 5 Jan 2005 03:47:02 -0800, pip <pip@discussions.microsoft.com> wrote:

>just forgot how to do it can some one plz help thanx
>
>ie
>1
>2
>3
>4
>5
>6
> ect all the way to 100