Adding new rows

[Paul Sheppard]

I have a spreadsheet with 100 rows in, I need to add a row after each
current row, is there a quick way to do this or have i got to insert
each new row individually?

 

[Bill Kuunders]

I assume you want to add an empty new row in between the existing rows.

One way would be with an extra column
Save as "trial" first.......just in case things get muddled up.
Give the existing rows uneven numbers and underneath them the same number of
rows with even numbers
copy and extend any required formula's
do a sort on the added column with the numbers

--
Greetings from New Zealand
Bill K
"Paul Sheppard" <[email protected]>
wrote in message
news[email protected]...

 

[Paul Sheppard]

Thanks Bill great tip, and it is really quite simple if you think abou
i