Adding new rows
 

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?


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390760

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"
wrote in message
news:Paul.Sheppard.1sumed_1122501923.8656@excelfor um-nospam.com...

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?


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390760

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


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390760