Excel auto increment number drag

[Darrenbilly]

Good morning,

I need to disable a feature in Excel. When highlighting a cell and dragging it down, if containing a number, it will increase by 1 for each row you drop down. I need to disable this feature. I know a little box pops up below the last cell, which lets you copy just the data, but I wish not to have to do this each time.

Thank you

 

[cliffordcooley]

I usually copy the cell to the second box. Then I highlight both boxes, this prevents the increment, and fills the same content that are in the two cells.