Insert blank row between each row of data

[Abox]

Method I'm using now is:
hold down ctrl key
select each row by clicking on the row number
right click, insert.
a blank row is then placed between each row.

This is very time consuming for large numbers of rows.

Any faster method?

 

[Mark W.]

On 2002-09-19 07:05, Abox wrote:
Mark W. - your answer gave me this idea:
In the first 3 cells of the first column to the right of my table, I entered 1,3, and 5. I then filled down to the end of the table, creating a column of odd numbers next to my table. Then I entered 2,4, and 6 underneath that, and filled down at least the same # of rows as my table, creating a column of even numbers in the blank rows. Then I sorted by my new column - the even numbered rows filled in between the odd numbered rows, and I had my spaces.

Thanks for the help!

Undoubtedly, there are a number of ways of implementing my sorting recommendation. Find one that you like and go with it.
This message was edited by Mark W. on 2002-09-19 08:33