• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Auto fill

How to disable auto fill feature in Excel

November 9, 2015 by Admin 15 Comments

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

Primary Sidebar

Recent Posts

  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel
  • How to Verify Email Addresses in Google Sheets: A Step-by-Step Guide
  • How to increase number of worksheets Excel

blogmines.com Copyright © 2023