Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .