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 know that you can type 1,2,3,4, and the select and drag the 4 numbers and Excel will automatically start numbering them as far down as you drag.

I was wondering if it would be possible for the numbers to stop at say 50, then continue from 51 in the next column?

So column 1 would contain the numbers 1-50, column 2 51-100, column 3 101-150, column 4 151-200 and so on, each column containing the next 50 numbers.

Sort of like this:

Column1       Column2
1             51
2             52
3             53
4             54
5             55
6             56
7             57


share|improve this question
I want to continue this on a couple more pages - continue what? numbering increase/ or the same pattern? or.......? please be more clear, and better provide the sample. – Peter L. Feb 19 '13 at 15:30
What is your question? What's stopping you from doing this? – CharlieRB Feb 19 '13 at 15:49

If '1' is in A1, put =a1+50 in B1 and drag to the right as far as required. Then select all the numbers in Row1 and drag the array down to Row50.

share|improve this answer

You must log in to answer this question.

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