Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 110
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,118
Default 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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,118
Default 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



  #8   Report Post  
Junior Member
 
Posts: 27
Cool

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.
:)


Quote:
Originally Posted by Terri
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stop excel from dropping the 0 in the beginning of a number? Rosewood Setting up and Configuration of Excel 12 April 4th 23 02:12 PM
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members Excel Worksheet Functions 1 April 7th 06 03:13 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
How do I insert the degree symbol in a column of numbers? JKB Excel Discussion (Misc queries) 3 July 6th 05 07:17 AM


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"