Auto count every other column

[doakurst]

Hey everyone,
I recently got a cd storage system that holds 500 discs in a box. I want to create an excel sheet where the first column and ever other column counts to 100. Where the first column is 1-100, the next column is 101-200 etc.. It there a function to do this or do I have to put that all in manually?
Thanks

[StephenR]

Put this formula in A1 and drag down or autofill:

=ROW()+(100*(COLUMN()-1)/2)

Then select A1 to B100 and drag across as far as necessary.