How to turn on or off Auto fill feature in Excel 2007?

Auto fill in excel is quite handy feature. Using this you can fill series of cells based on the entries of other excel cells. 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.

Source:
http://blogmines.com/blog/2010/02/18/how-to-turn-on-or-off-auto-fill-feature-in-excel-2007/