View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Adding an extra row after every existing row

If just for visual purposes, simply select all rows, which are the 1,2,3,4,5 and
not the columns which are A,B,C,D and double their height.

If you truly need a row inserted, in a helper column enter numbers 1 to 61.

Copy that range and paste to row 62.

Sort on that column ascending to get your blank rows.


Gord Dibben MS Excel MVP


On Sun, 13 Apr 2008 07:10:00 -0700, Josh W
wrote:

I have an excel worksheet with about 61 rows. Now i have to add another row
with the same text after EACH existing row - between row A and B, row B and C
etc. Is there any quick way to insert all these rows or do I simply have to
manually insert row by row.