Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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 Oct 22 '12 at 4:17

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.