NUMBER LISTS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to enter several hundred numbers in one colum. But would like to
expel some of the time it will take to do so.. Is thier a quick way to do
this...
 
What kind of numbers? A series of sequential numbers?

To enter 1 to 500 in column A starting in A1:

Enter 1 in A1
Select all of column A by clicking on the column header
Goto the menu Edit>Fill>Series
Series in: columns
Type: linear
Step value: 1
Stop value: 500
OK
 
A slight tweak to Biff's suggestion will work:

Put 8300 in a cell and select that cell

From the Excel main menu:
<edit><fill><series>
Series in: COLUMNS
Type: Linear (the default)
Step Value: 1 (the default)
Stop Value: 9100
Click [OK]

That will create the series 8300 through 9100, beginning in the current cell.

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

XL2003, WinXP
 
It is Sequintial numbers line 8300-9100 needing all number inbetween

Does that mean you need:

8300-9100
8301-9100
8302-9100
8303-9100
...
...
9099-9100

If that's the case...

Assume you want these numbers starting in cell A1
Hit function key F5
In the Reference box, type A1:A800 (you need 800 sequential numbers
9100-8300 = 800)
OK

A1 will be the active cell
Type this formula but *do not hit ENTER* :

=8300+ROW()-1&"-9100"

After you type the formula hold down the CTRL key then hit ENTER
This will fill the cells with the numbers.
With the range of cells still selected
Goto the menu Edit>Copy
Then Edit>Paste Special>Values>OK

That's it. You now have your sequential numbers.
 
Back
Top