View Single Post
  #3   Report Post  
Kevin M
 
Posts: n/a
Default

John, if you type 2 in A1, then 4 in B1 and 6 in C1 then
highlight the whole range, then autofill down Excel will
get the picture and continue to autofill by increments of
2.

As far as highlighting every other cell, you can't.
Unless you're talking about typing the text M80 and doing
an auto fill from that, that's the same as above.

HTH

Kevin M
-----Original Message-----
Say i want to increment by 2 in a fill How do I do that?
Also, How do I increment a fill series =M80 by other

than 1 so the next cell
call out would be M82 then M84 etc..
.