If just for appearance sake, I would double the row heights to give the illusion
of double-spacing.

Having blank rows could lead to problems later with copying, sorting, filtering,
pasting and other functions.


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 09:58:03 -0700, BBB Jean <BBB
wrote:

I have a document 500 rows long. Each row has text. I would like to insert
a blank row after every row that text is in, leaving a document that has a
blank row every other row. Can't seem to locate an easy answer. I thought
holding the CTRL button would do it (while selecting) but not so. Can anyone
help?