How to disable auto fill feature in Excel

Auto fill in excel is quite handy feature, using this you can fill series of cells based on the entries of other excel cells. But if you want to turn off or disable auto fill feature then you can use Excel options for doing this. Listed below are the steps to turn off auto fill in Excel 2013, Excel 2010 and Excel 2007

Excel 2016, 2013 and 2010

Click on the File menu –> Options link and navigate to Advanced tab on the left hand side.

enable or disable auto fill feature in Excel 2013 and Excel 2010

Under Editing options, un tick the check box with label as Enable fill handle and cell drag-and-drop. This will turn off the auto fill feature in Excel 2010.

Excel 2007

In Excel 2007, this feature can be turned on or off using the Excel Advanced Options.

Click on the Office button –> Excel Options

Excel 2007 Options

Under Excel Options select Advanced section

Turn off Auto fill in Excel 2007

By checking or un checking “Enable fill handle and cell drag-and-drop”, you can turn on or off the Auto fill feature in Excel 2007.

Also See: How to disable autocomplete suggestion feature in Excel 2010

In Category: Excel 2007, Excel 2010, Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 15 Comments
  • umar August 27, 2011, 10:56 am

    Thanx for the information.. It helps me finding the solution of enabling the autofill feature in my Excel.

    reagrds

  • Woo June 2, 2012, 8:11 pm

    WARNING!
    This does not actually turn off auto-completion! It just turns off auto-fill, so if you type something and move to another cell, Excel can still auto-complete your cell with another random value you typed in earlier.

    Turning off auto-completion option is just few lines below the auto-fill option 😉

  • Azrael August 27, 2013, 10:54 am

    Woo, that was helpful! I came to this page hoping for some answers on AutoComplete and not AutoFill which I presently have no problems with. You’re a surprise, I should say. I am entering sensitive data for each individual in a manifest of 50 people. My entry sometimes gave individuals the wrong entry because of this AutoComplete feature. AutoComplete is dangerous. I even turn it off in my web browser. Entering the right data in a cell could mean life and death, won’t you agree?

  • Peter March 20, 2014, 1:09 am

    FYI, if you want to keep the AutoFill handle, but disable the AutoFill Options box that pops up after dragging and releasing the handle: Still on the File\Options\Advanced tab, under “Cut, Copy, and Paste,” clear the “Show Paste Options button when content is pasted” check box.

  • Ravi Shankar March 20, 2014, 8:38 am

    Thanks for the info.

  • Charles July 13, 2014, 10:10 pm

    Didn’t help me! Im trying to type “5-7” in a cell but it keeps auto changing it to 5th-july how can i stop this from happening, very frustrating

  • Ravi Shankar July 14, 2014, 10:45 am

    Disabling auto fill will not solve this problem. Can you please try this http://blogmines.com/blog/disable-conversion-of-two-numbers-with-hyphen-as-date-in-excel/

  • Mike Robinson August 28, 2014, 4:03 pm

    Very helpful. When I did this I found it was already enabled. So I turned it off & on again & it was enabled. Only problem was that when I did it on another column, same thing it didn’t work but the ticks were in the right boxes. I can keep turning on & off again but it rather misses the point of the facility. Any thoughts gratefully received. ATB
    Mike

  • Ravi Shankar August 28, 2014, 9:38 pm

    Bit strange, can you send me the file with an example to this address – ravi@rshankar.com

  • Dathatreya Ch January 19, 2015, 2:41 pm

    Thank you so much

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.