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" wrote in message
...
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. EditFillSeriesLinearStep=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(). Dragcopy down to row 100.


Gord Dibben Excel MVP

On Wed, 5 Jan 2005 03:47:02 -0800, pip 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