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.
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
Under Excel Options select Advanced section
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