We help IT Professionals succeed at work.

Insert rows in a spreadsheet

jtr209
jtr209 asked
on
Is there a quick method to inset a a row between each existing row in an excel spreadsheet?

Thanks
Comment
Watch Question

With macro or without macro?

Author

Commented:
Either?
Without macro

Number your rows with odd numbers - 1, 3, 5, 7, 9.... - in a blank column using "Fill Series"
Number the following rows (without data) with even numbers for as many rows as were with data.

now sort the entire range on that column and then delete the column.

Author

Commented:
Can I sort by odd #'s - what do I sort by?

Author

Commented:
NVM - I got it - Thanks