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

Contributor

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.

 

bbsin_0-1657801494503.png

 

 

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.

@Riny_van_Eekelen 

 

HI Thank you.  That's what I did but when I drag it display as the 1st cell number not running.