A quick way to insert rows

[madadd]

Hello,

I've got a list thats about 700+ rows long. I need to add 10 spaces between each of the values in the column. Normally, I'd right click in between 2 values, insert row and repeat 9 times, but doing that 700 times doesn't sound fun at all. Anyone have a quick and easy for this?

[ChemistB]

Yes, let's say your data is from A:M. In N2 (where your data begins) enter 1, in N3, enter 2. Then select N2:N3 and drag down (or if there are no blanks in M, you can double click on the lower right hand corner and it'll self fill) to the last used row (i.e. 705). Then Copy and paste those values in N706, N1412, etc, 9 more times.
Select your entire range including column N and Sort by Column N, smallest to largest.
Delete column N. Does that work for you?

[madadd]

Ooo, very clever. I got a little confused because my data is only in Column A. So I did the numbers in B and copied 9 times, sort, and viola! Kinda makes me sad I didn't think of this :/