Well, you could add a helper column and enter 1, 3, 5, and copy down to
the bottom of what you've got. You could then put 2,4,6,8 ... in blank rows
until you have the max # of what you need. Then sort by the helper column.
Make sure you save a pristine copy and operate on a secondary copy so you
don't damage your good file.

"KopRed" wrote in message
...
I have several spreadsheets with between 2,000 and 3,000 rows of data. I'm
using them to import data into some accounting software. The format
required
by the software is that each row of data is separated by a blank row.
Short
of individually inserting several thousand rows, does anyone know another
way
of changing the layout of the spreadsheet?