View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Inserting Multiple Rows

Copy 16 empty rows.
Right-click on a cell and choose Insert copied cells.

--
Kind regards,

Niek Otten


"Mike" wrote in message
...
Is there a way to insert multiple rows at a single time? Let me see if I
can
explain.
I have an existing worksheet contain several hundreds rows on data. I want
to insert 16 new rows between each existing row of data. I can do this by
going to each row and inserting the rows but I was hoping there would be a
way to this in one fell swoop.

Any thoughts.