fill down cells (column) using ctrl-g

[eholz1]

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

 

[ward376]

You can double-click the fill handle(plus sign).

 

[Jim Rech]

Edit, Fill, Series.

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

 

[Guest]

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.