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

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

Edit, Fill, Series.

--
Jim
"eholz1" wrote in message
ps.com...
| 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
|

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