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.
|