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

T

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?
 
T

tony h

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

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

regard
 
J

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.
 
Top