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