Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Is there a way to automatically list numbers? For example I want to make a
number list from 1-3000. If I enter 1 can Excel list the rest automatically? |
#2
![]() |
|||
|
|||
![]()
Enter 1 in the first cell, 2 in the second, select both cells, move the
cursor to the bottom right of the cells until it changes to a black cross, and drag down (Or across) until complete. -- HTH RP (remove nothere from the email address if mailing direct) "toddb123" wrote in message ... Is there a way to automatically list numbers? For example I want to make a number list from 1-3000. If I enter 1 can Excel list the rest automatically? |
#3
![]() |
|||
|
|||
![]()
One method.....there are many.
Enter 1 in A1. Go to Name Box left of Formula Bar and type A1:A3000 then hit ENTER key. EditFillSeriesLinearOK Gord Dibben Excel MVP On Wed, 20 Apr 2005 15:55:02 -0700, "toddb123" wrote: Is there a way to automatically list numbers? For example I want to make a number list from 1-3000. If I enter 1 can Excel list the rest automatically? |
#4
![]() |
|||
|
|||
![]()
Also, in cell A6 (for example) enter =ROW()-5 (will produce 1 ) , then
copy down as far as you like This method especially helpful if you later add or delete rows as auto-renumbering will take place,, may or may not be something you would want. HTH "Gord Dibben" <gorddibbATshawDOTca wrote in message ... One method.....there are many. Enter 1 in A1. Go to Name Box left of Formula Bar and type A1:A3000 then hit ENTER key. EditFillSeriesLinearOK Gord Dibben Excel MVP On Wed, 20 Apr 2005 15:55:02 -0700, "toddb123" wrote: Is there a way to automatically list numbers? For example I want to make a number list from 1-3000. If I enter 1 can Excel list the rest automatically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a list of sequential numbers using Excel or Acces. | Excel Discussion (Misc queries) | |||
How can I compare a number against a list of numbers | Excel Worksheet Functions | |||
I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
Alphabetical list of Numbers are not correct! | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |