fill down cells (column) using ctrl-g
Enter 0 in a1, 1000 in a2
Highlite those 2 cells and then use ctrl+g
Once your 200 cells are highlited, use alt+e, then i, then s, and enter.
--
smither fan
"eholz1" wrote:
Hello Excel Group,
I can use ctrl-g to select cells from a1 to a200 (for example) using
shift-enter.
is there a way to fill the range with values? Like a1 = 0, a2 = 1000,
a3 = 2000, etc
and fill series down to a200 without grapping the "plus sign" and
dragging the series down to a200?
Thanks,
eholz1
|