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?