Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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
1  
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
add comment

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
add comment

Your Answer

 
discard

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.