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.
|