May 27, 2013

Unable to drag cell corner in Excel to auto-increment?

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.

  1. Select Office Button
  2. Select Excel Options
  3. Select Advanced
  4. 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:

Anonymous said...

Superb.. Thank you...

Anonymous said...

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.

RK said...

Awesome thanks mate....this hadbeen troubling me for some time.

Anonymous said...

Thank you...It works

Anonymous said...

Thanks alot..
that was really helpful

Praveen

Unknown said...

Thanx for guide

Hasnain
pnb, co noida