• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • About
  • Portfolio
  • Privacy Policy

How to disable auto fill feature in Excel

November 9, 2015 By Ravi Shankar Leave a Comment

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

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, Excel 2016, MS Office Tagged With: Auto fill, Disable, Enable auto fill, Excel, Turn Off

Reader Interactions

Comments

  1. umar says

    August 27, 2011 at 10:56 am

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

    reagrds

    Reply
  2. Woo says

    June 2, 2012 at 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 😉

    Reply
  3. Azrael says

    August 27, 2013 at 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?

    Reply
  4. Peter says

    March 20, 2014 at 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.

    Reply
    • Ravi Shankar says

      March 20, 2014 at 8:38 am

      Thanks for the info.

      Reply
  5. Charles says

    July 13, 2014 at 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

    Reply
    • Ravi Shankar says

      July 14, 2014 at 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/

      Reply
  6. Mike Robinson says

    August 28, 2014 at 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

    Reply
    • Ravi Shankar says

      August 28, 2014 at 9:38 pm

      Bit strange, can you send me the file with an example to this address – [email protected]

      Reply
  7. Dathatreya Ch says

    January 19, 2015 at 2:41 pm

    Thank you so much

    Reply

Trackbacks

  1. How to disable autocomplete suggestion feature in Excel 2010 says:
    June 4, 2011 at 6:24 pm

    […] to disabling auto fill feature, Excel 2010 provides option for disabling the autocomplete suggestion feature as well. This […]

    Reply
  2. Fill rows and columns with Time values in Excel says:
    July 8, 2013 at 8:43 am

    […] of manually entering these values, we can automatically generate using the TIME function and excel auto fill […]

    Reply
  3. Group people based on the month in Excel 2013 says:
    July 19, 2013 at 7:43 am

    […] 3: Now use the Excel auto fill feature to copy the formulas for the other students to find out month from their date of […]

    Reply
  4. Post recap – Simple tutorials on Microsoft Excel 2010 says:
    October 21, 2013 at 7:59 am

    […] How to disable auto fill feature in Excel 2010 […]

    Reply
  5. A trick to flip a column upside down in Excel says:
    February 17, 2016 at 12:49 pm

    […] 1: Insert a new column before the existing column.Step 2: Now use Auto Fill feature to fill the temp with numbers as shown […]

    Reply

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • We have blocked all requests from this device – Firebase Phone Authentication
  • iPhone is not available error message in Xcode
  • Clear CocoaPods cache, re-download and reinstall all pods
  • PDFKit – View, Annotate PDF file in Swift
  • Tab Bar Controller with WebView

Archives

  • September 2020
  • April 2020
  • December 2019
  • November 2019
  • October 2019
  • February 2019
  • October 2017
  • June 2017
  • May 2017
  • March 2017
  • September 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • October 2013
  • August 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
  • March 2011
  • January 2011
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • July 2009
  • March 2008

Copyright 2020 © rshankar.com