I got a file that's 5,000 rows long. Can I ad a blank row every other row so
it's easier to read w/o inserting a row 5,000 times over again?

You can but you might find that increasing the row height gives you much
the same effect and does not lose functionality.

If you really want to insert rows post again here and I might put in
some code

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552066

ASAP Utilities, a free Add-in available at www.asap-utilities.com has a
feature that does this in a snap.

Vaya con Dios,
Chuck, CABGx3


"thorn" wrote in message
...
I got a file that's 5,000 rows long. Can I ad a blank row every other row
so
it's easier to read w/o inserting a row 5,000 times over again?

One other way I've seen suggested on this forum: In an empty column, number
1, 3. Select these two cells and drag down to row 5000. Excel should finish
the numbering. Then in the first empty cell in this column below your data
(row 5001), number 2, 4 and fill down to row 10,000. Then sort your data
using this helper column and delete it when you're done.

"thorn" wrote:

I got a file that's 5,000 rows long. Can I ad a blank row every other row so
it's easier to read w/o inserting a row 5,000 times over again?