Adding an extra row after every existing row
Thanks very much Gord, now it works fantastic!! the "now header row" click
was a good tip.
"Gord Dibben" wrote:
Let's go over it again.
1. In row 1 of an an adjacent blank column....say H1... enter 1.
2. In H2 enter a 2.
3. Select both those cells and double-click fill handle of H2 to copy down to
H61.
4. Select H1:H61 and Copy.
5. Select H62 and Paste.
6. Select all your used columns including H and DataSort "My data range has
no header row"
7. Sort Ascending on column H to get
1
1 blank
2
2 blank
3
3 blank
8. Delete Column H
Gord
On Sun, 13 Apr 2008 10:22:01 -0700, Josh W
wrote:
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.
|