Adding an extra row after every existing row
Sorry Gord, I know you are trying to help but I really couldn't follow you. I
tried to understand and do what you suggested several ways but all that
happens is that the existing data remain exactly as before and I only got an
extra 61 rows AFTER the existing rows and not each one in between.
"Gord Dibben" wrote:
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.
|