Why is the number running as the 1st number when it's drag?




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



2 Replies

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