Monday, August 29, 2011

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

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

Under Excel Options select Advanced section

image thumb77 How to turn on or off Auto fill feature 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.


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

No comments:

Post a Comment