Forum Discussion
Drag to Copy Cells
Ah...I have found the issue. Just because a cell contains numbers, as well as text, it is not always eligible to be made into a series. That explains it.
I don't have a golden rule for when Excel will decide to auto increment during a fill or not but if you WANT it to increment you will have much better success if you have a sequence that already increments highlighted before you drag the corner down. So in your example if you had 1-10 highlighted and pull the corner down it will increment and give you 1-20. If you only highlight 10 and pull down, not sure if/when it would or would not increment. If you specifically do NOT want it to increment (e.g. you want to fill down an item like "ABC123"), then if you Copy and then Paste into the whole range it will NOT increment.
hope those tips help