Is there a way to create a list of numbers in Excel without having to type every single number? For instance 1-100. And then it'll list all the numbers in between. Is that even possible?
2006-12-04 09:56:45 · 3 answers · asked by Crazy_in_love 1 in Computers & Internet ➔ Software
Type 1 in the first box and 2 in the second box.
When you highlight both boxes, a small black cross is visible in the bottom right corner of box 2.
Click on this cross and drag it down to the 100th box.
Excel will have filled-in the numbers for you.
2006-12-04 10:04:06 · answer #1 · answered by Sm.mS 3 · 2⤊ 0⤋
Suppose you type 1 in cell A1, then move to the next cell B1 and write =1+A1, this will assign the value 2 to the cell B1, now on the bottom right corner of cell B1 you will see a small black square. If you take your mouse arrow to the square, it will turn into a cross or a plus sign. Now all you do is click on the cross and drag the mouse down until you reach 100 and you'll see that excel has done your work for you. hope this helps.
2006-12-04 10:10:43 · answer #2 · answered by ratel 3 · 0⤊ 0⤋
Type in 1 in the first field. Then go to Edit > Fill > Series. You can do different things. But to go from 1-100, you can type in 100 in stop value. Then, select row or columns. If you select column, then A1 through A100 would be filled in.
This will also work with dates and other sequence patterns.
2006-12-04 10:11:54 · answer #3 · answered by techman2000 6 · 0⤊ 0⤋