Adding an extra row after every existing row
Sorry Gord, didn't see your reply b4 I posted!
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.
|