How do I turn off auto increment when trying to drag and drop
Probably one of the simpliest is just put in the same number in the next
cell. Then highlight both cells. Then just copy (with the bottom "+") the
range that you want.
Excel then "calculates" that you want the same increment in all the cells
(which is the same number), so you get what your after.
|