how do I quickly insert numbers 1 to 100 in a column in Excel?
 

I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I

Answer: how do I quickly insert numbers 1 to 100 in a column in Excel?
 

Yes, there is a quick and easy way to insert numbers 1 to 100 in a column in Excel. Here are the steps:

1. Start by typing the number 1 in the first cell where you want to start the sequence (for example, cell A1).
2. Next, click on the cell with the number 1 and hover your mouse over the bottom right corner of the cell until you see a small black cross.
3. Click and hold the small black cross and drag it down the column to the last cell where you want the sequence to end (for example, cell A100).
4. Release the mouse button and Excel will automatically fill in the rest of the numbers in sequence from 2 to 100.

That's it! You should now have a column with numbers 1 to 100 in sequence. This method is called "AutoFill" and can be used for other types of data as well, such as dates or text. Simply type the first value in the series and drag the fill handle to complete the series.

how do I quickly insert numbers 1 to 100 in a column in Excel?
 

1 in a1
2 in a2
grab BOTH cells, drag down

--
Don Guillett
SalesAid Software

"terri" wrote in message
...
I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there
way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I

how do I quickly insert numbers 1 to 100 in a column in Excel?
 

Easiest way:

Enter 1 in first row.
Enter 2 in second row.
Select *both* cells.
*Double click* on the "fill handle" of the 2 cell selection, which will
automatically fill all the rows in that column, as far down as there is data
in the adjoining column.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"terri" wrote in message
...
I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I

how do I quickly insert numbers 1 to 100 in a column in Excel?
 

Here's one way.

Put a 1 in the first cell

Type these keys: [alt] E I S (short cuts for <edit<fill<series)
Check: Columns
Stop Value: 100
Press [enter]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"terri" wrote:

I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I

how do I quickly insert numbers 1 to 100 in a column in Excel?
 

And yet another.

Enter 1 in first cell.

Right-click on fill handle and drag down.

Release button and select "Fill Series"


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 09:27:02 -0800, Ron Coderre
wrote:

Here's one way.

Put a 1 in the first cell

Type these keys: [alt] E I S (short cuts for <edit<fill<series)
Check: Columns
Stop Value: 100
Press [enter]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"terri" wrote:

I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I

how do I quickly insert numbers 1 to 100 in a column in Excel?
 

Being a dyed-in-the-wool keyboarder, I'm drag-fill aversive....but...
Here's what I'd really like to see....

Put a 1 in a cell
Right-click the fill handle and drag down 1 cell
....Select "Series" from the popup menu
....Enter 100 in "Stop value" (other settings would already be filled properly)
....Press [enter] and the series would extend all the way to 100

But, alas, no....it stops as 2

***********
Regards,
Ron

XL2002, WinXP


"Gord Dibben" wrote:

And yet another.

Enter 1 in first cell.

Right-click on fill handle and drag down.

Release button and select "Fill Series"


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 09:27:02 -0800, Ron Coderre
wrote:

Here's one way.

Put a 1 in the first cell

Type these keys: [alt] E I S (short cuts for <edit<fill<series)
Check: Columns
Stop Value: 100
Press [enter]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"terri" wrote:

I have a list of itmes that need to be numbered to the right side of the
list. I do not wish to manually enter each number (1 to 100). Is there way
I can enter the number 1, then pull the cursor down the column until the
cells become populated with the rest of the numbers in sequence? I

assuming that the list is on a continuous rows - no space row in between - all rows are to be numbered in sequence 1 to 100,,,.

1. select the row before the last row - drag the selection up to the 2nd row of list. then hide rows.
2. type "1" in this cell at the first row, then drag down to the last row, from the bottom right corner handle of the first cell.
:)