View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ross Ross is offline
external usenet poster
 
Posts: 152
Default 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