How to create a list from "12001" to "13001" in Excel?
Plz help!
2007-08-05 02:50:01 · 3 answers · asked by John L 1 in Computers & Internet ➔ Programming & Design
1 - Type in the first cell (12001).
2 - Type in the second cell (12002).
3 - Select the two cells you typed in.
4 - Click the bold point in the right down corner of the selection and drag it down to create the list until you reach 13001.
2007-08-05 03:03:01 · answer #1 · answered by H . B . K 2 · 1⤊ 0⤋
If you want to "Fill" a col with these numbers.
In the first cell enter
12001
then, 12002
12003
Then highlight from the first cell at 12001, down the col until enough rows are highlighted, a few more is OK, to contain the number you desire. It will not fill beyond your desired number.
Click Edit
Fill
Series
Leave "Series" in rows
Leave "Type" at Linear
Leave "Step Value" at 1
Enter "Stop Value" at 13001
You can also fill across by columns. Follow the directions in "Fill" menu.
2007-08-05 10:12:20 · answer #2 · answered by ed 7 · 1⤊ 0⤋
Key in 12001 then use the pointer to scroll down to 13001 - there you are.
2007-08-05 09:59:11 · answer #3 · answered by Anonymous · 0⤊ 0⤋