1)Put a 1 in any cell
2)Then click and hold the left mouse button on the lower right corner of the
cell (the cursor will turn into a cross)
3)Hold down the [Ctrl] key and drag the sequence down as far as you'd like.
Or
1)Put a 1 in any cell
2)Starting with that cell, paint a vertical range of 100 cells.
3)EditFillSeries.
Click [OK]
Will one of those methods work for you?
--
Regards,
Ron
|