Jul 14 2022 05:25 AM
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
Jul 14 2022 05:32 AM - edited Jul 14 2022 05:34 AM
@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.
Jul 14 2022 09:46 PM
HI Thank you. That's what I did but when I drag it display as the 1st cell number not running.