TechSpot

Excel auto increment number drag

By Darrenbilly
May 18, 2015
Post New Reply
  1. 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
     
  2. cliffordcooley

    cliffordcooley TS Guardian Fighter Posts: 8,551   +2,894

    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.
     

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...