need help with copying rows and making new rows

[meh]

I have a spreadsheet of about 50 rows. I need a way to copy the text
in say row 2 and make two new rows under it with the same text as in
row 2 right under it. but i want to do it for all the rows. any
ideas?

 

[David McRitchie]

See
http://www.mvps.org/dmcritchie/excel/insrtrow.htm

you want to remove the line of code that removes
constants retaining only formulas.