TechSpot

  1. TechSpot Forums are dedicated to computer enthusiasts and power users. Ask a question and give support. Join the community here.
    TechSpot Forums are dedicated to computer enthusiasts and power users.
    Ask a question and give support.
    Join the community here, it only takes a minute.
    Dismiss Notice

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,849   +3,068

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