Thread: Adding rows?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Adding rows?

Use a new column
put in the top part of that column a number series 1 3 5 7 9 etc till all
lines with existing data have a number
and in the bottom part of that column 2 4 6 8 etc
then select the whole range and sort by this new column
delete the column after.
Greetings from New Zealand
Bill Kuunders
"cambanis" wrote in message
...
Hello everyone!
I have a spreadsheet full of data (560x15) and I would like to add one new
row bellow each one existing (1120x15).
Can I do it? (I can manually select rows one by one having CTRL pressed
and
then insert Insert Row, but it takes a lot...)
Thanks