how do i make a list ie 1 to 100

[pip]

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

 

[Bob Phillips]

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

 

[Gord Dibben]

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