| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
- 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! |
|
#4
|
|||
|
|||
|
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! |
|
#5
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting specific # of rows | Excel Discussion (Misc queries) | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Inserting Rows w/formulas question | Excel Worksheet Functions | |||
| inserting rows through external data source | Excel Discussion (Misc queries) | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
Linear Mode
