Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
select unique to make list | Excel Worksheet Functions | |||
Make Data validation List Alphabetical?? | Excel Worksheet Functions | |||
make list of information from different cells | Excel Worksheet Functions |