Insert rows in a spreadsheet

jtr209
jtr209 used Ask the Experts™
on
Is there a quick method to inset a a row between each existing row in an excel spreadsheet?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial