If you ever run into the issue of not able to get auto-incremented numbers when you drag cell corner in Excel, then this is for you.
Note that this is for Excel 2007. A similar option should be present in earlier/later versions as well.
- Select Office Button
- Select Excel Options
- Select Advanced
- Tick the check-box “Enable fill handle and cell drag-and-drop”
Note that this is for Excel 2007. A similar option should be present in earlier/later versions as well.
6 comments:
Superb.. Thank you...
Thanks. That helped. Further, I still had to select Fill series from the menu that appeared next to the cells selected in the end before I got the incremental numbers.
Awesome thanks mate....this hadbeen troubling me for some time.
Thank you...It works
Thanks alot..
that was really helpful
Praveen
Thanx for guide
Hasnain
pnb, co noida
Post a Comment