Inserting rows
 

I have a spreadsheet that is approx. 200 rows long and I need to insert a new
row after each existing row. Please help!

Thanks for your time!

ASAP Utilities has a feature that does this nicely...........ASAP Utilities
is a
Excel add-in, and is available free at www.ASAP-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Linda T" <Linda wrote in message
...
I have a spreadsheet that is approx. 200 rows long and I need to insert a
new
row after each existing row. Please help!

Thanks for your time!

- add a column
- in the new column, for your existing data, insert ascending odd numbers
1 - 399 (1, 3 then use Fill Series)
- in the next 200 empty rows, insert ascending even numbers 2 - 400
- Sort on the column
- Delete the column

HTH,
--
George Nicholson

Remove 'Junk' from return address.

"Linda T" <Linda wrote in message
...
I have a spreadsheet that is approx. 200 rows long and I need to insert a
new
row after each existing row. Please help!

Thanks for your time!

Thank you for replying...I downloaded ASAP Utilities and it did exactly what
I wanted it to do in just a couple of mouse clicks!

You saved me ALOT of time...thanks again!
Linda T.

"CLR" wrote:

ASAP Utilities has a feature that does this nicely...........ASAP Utilities
is a
Excel add-in, and is available free at www.ASAP-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Linda T" <Linda wrote in message
...
I have a spreadsheet that is approx. 200 rows long and I need to insert a
new
row after each existing row. Please help!

Thanks for your time!

You're quite welcome...........thanks for the feedback...........

Vaya con Dios,
Chuck, CABGx3


"Linda T." <Linda wrote in message
...
Thank you for replying...I downloaded ASAP Utilities and it did exactly
what
I wanted it to do in just a couple of mouse clicks!

You saved me ALOT of time...thanks again!
Linda T.

"CLR" wrote:

ASAP Utilities has a feature that does this nicely...........ASAP
Utilities
is a
Excel add-in, and is available free at www.ASAP-utilities.com

Vaya con Dios,
Chuck, CABGx3



"Linda T" <Linda wrote in message
...
I have a spreadsheet that is approx. 200 rows long and I need to
insert a
new
row after each existing row. Please help!

Thanks for your time!