Auto increment in Excel (2007, 2010) by drag cell corner

In Excel (2007/2010) you can auto increment by dragging cell corner. But some how excel drag was not working in newer installation of excel on my machine. After 10-15 minutes of struggle I was able to fix that.

Did you also not able to auto-increment by drag cells in excel?

I am providing step by step process to enable auto increment by dragging cell corner in excel (2007/2010). Its quick and take less than 10 seconds.

Step 1:

For excel 2007 click on office icon on top left excel-2007

For excel 2010 click on “File”  on top left excel-2010


Step 2:

For excel 2007 click on the Excel Options

excel 2007 options

For excel 2010 click on the options

excel 2010 options


then go to “Advance” for excel 2007/2010.

Excel 2007 2010 auto increment enable by drag cell


Under “Edit Options” there is a check box named “Enable fill handle and cell drag-and-drop”. Select the check box to enable the auto increment.

That’s it!!! now you have enabled excel (2007/2010) auto increment drag cell corner.

Hope this help!!!

Tags: ,


  1. Thanks dear. you have made it look so simple. You were very clear in explaining steps to fix the problem and thats what really matter. keep it up.

  2. Thanks so much :)

  3. Language not a barrier!!! Good intentions don’t need a language….

  4. thank you very much

  5. superb…….

  6. Thank you so much for this post :)

  7. Thanks for the tip.
    I was struggling since many months with this but never thought to look it up and when i did your site helped me solve the problem.

  8. Mahesh,

    My Excel 2010 spreadsheet already has the boxes checked and it does not increment when dragging the corner down. I’ve tried changing the format of all cells in the column and it still does not work. Any ideas?

  9. Tanx…….So much..!!!

  10. Great summary. This worked very well.

  11. Amarjeet Singh Bajwa

    Thanx very much for solving this problem of dragging the cells even the acer engineer was not able to solve this he simply reinstall the MSOffice.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>