can I ad blank rows every other row to a whole excel doc?

[thorn]

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?

[tony h]

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

[CLR]

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" <thorn@discussions.microsoft.com> wrote in message
news:C0F0E06D-0C7A-4197-B6C2-3D1C8DE15991@microsoft.com...
> 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?

[JMB]

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?