View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Danny C Danny C is offline
external usenet poster
 
Posts: 24
Default 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.