If this is to just make it pretty (double spaced) when you're printing, then
maybe you could just select the entire range and double the rowheight of the
rows.

If you need to add extra rows for a different purpose, you can:

Insert a new column A.
Put 1 in A1
Put 2 in A2
Select A1:A2
and fill down those 500 rows

Select A1:A500
copy that range
Select A501 (the first cell under your data in column A)
Paste the numbers there.

Sort your data by column A (ascending order)

delete column A

jetanddug wrote:

In 500 rows of data, is there a formula to insert a row after every row of
data? I don't understand programming so if the response requires this,
please explain as if to a pre school student!

--

Dave Peterson