View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Adding an extra row after every existing row

Just elaborating on Gord's explanation:

Say existing data in A1 to A61.
Insert a *new* (helper) column A by right clicking in the existing Column A
header and choosing "Insert".

In the NEW Column A, enter 1 in A1, and 2 in A2.
Select A1 and A2.
In the lower right corner of this 2 cell selection you'll see a small black
square, called the "fill" handle.

Hover the cursor over this square until it (the cursor) changes from a fat
white cross to a skinny black cross.
Then *double* click.

This will *automatically* fill the series down Column A, as far as there is
data in Column B.

This gives you the numbers 1 to 61 in the column next to your data in Column
B.