A
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
B
Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
C
Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
D
All of above
Option A:
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
No comments yet. Be the first to comment!