NUMBER LISTS
 

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

NUMBER LISTS
 

What are the numbers? Give us an example.

"jblev" wrote in message
...
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...

NUMBER LISTS
 

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 EditFillSeries
Series in: columns
Type: linear
Step value: 1
Stop value: 500
OK

--
Biff
Microsoft Excel MVP


"jblev" wrote in message
...
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...

NUMBER LISTS
 

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

"jblev" wrote:

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

NUMBER LISTS
 

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


"jblev" wrote:

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

"jblev" wrote:

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

NUMBER LISTS
 

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 EditCopy
Then EditPaste SpecialValuesOK

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

--
Biff
Microsoft Excel MVP


"jblev" wrote in message
...
It is Sequintial numbers line 8300-9100 needing all number inbetween

"jblev" wrote:

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