View Single Post
  #4   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

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.