Take the 2-minute tour ×

I need to populate the same number 10 times in a row, then the next number up on the next row.

starting at 0, ending at 1000

for example:

1 1 1 1 1 1 1 1 1 1
2 2 2 2 2 2 2 2 2 2
3 3 3 3 3 3 3 3 3 3
1000 1000 1000 1000 1000

and to 1000

I need to print out these numbers to cut up and put each row of numbers in each envelope to be sold for a Chinese auction at a benefit.

How do I do this dynamically without entering in all of the rows by hand?

share|improve this question

3 Answers 3

In the address box (just left of the formula bar), type A1:J1000, enter (this will select your 10 columns, 1000 rows), type=row(), then Ctrl+Enter. You're done.

share|improve this answer

Enter four cells like this:

1 1
2 2

Select all four cells and drag right to fill your first two rows.

Now select these two rows and drag down.

share|improve this answer
If you're going to do it this way, you actually only have to fill in the first 2 cells. :) –  Daniel Cook Oct 22 '12 at 4:17

Just enter first two rows manually. Then select all 1s and 2s and start dragging from the right-bottom corner of the selection downwards. You selection will be expanded with values automatically filled with incrementing 1s and 2s downwards.

share|improve this answer

Your Answer


