Forum Discussion
Why is the number running as the 1st number when it's drag?
hi I am trying to drag to have the number auto fill as 2 ,3, 4... but when I hightlight and drag the icon it display as 2 in all the rows. anyone can help me? Thank you
bbsin Enter a 2 in the first cell, then a 3 in next. Select them both and drag. Now Excel will see the pattern and increase each following cell by 1.
HI Thank you. That's what I did but when I drag it display as the 1st cell number not running.