Fill Handle Not Working in MS Office Excel 2010 and 2007
While Working on Excel I observed Fill handle not working as expected, I was trying to fill adjacent cells with a series of data which can be done when you drag the fill handle but there was no + option (as shown in below image) visible near the fill handle to drag it.
Here is the solution for this problem. You have to Enable fill handle and cell drag-and-drop option in Excel Settings
Follow the Below Steps for Excel 2010
1- Open Excel and go to File Menu on Top left side and then navigate to options ( as shown in below image )
2- From options menu go to Advanced section, then go to Enable fill handle and cell drag-and-drop option and check mark this option ( as shown in below image) to enable it.
Follow the Below Steps for Excel 2007
If you have Excel 2007 then the method is similar only difference is in the Step 1 on how to go to Advanced options.
To go to Advanced options in Excel 2007 follow below steps
1- Open Excel
2- Click on Office Button ( Round Button with Windows Icon ) found on top most left side
3- Click Excel Options ( as shown in image below)
4- To enable fill Handle follow the Step 2 above listed for Excel 2010.