Where is my autofill handle?

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010




Nobody knows why this happens but sometimes the 'autofill' handle disappears from your Excel worksheet cell and creates a panic that is not easy to understand. Where is my autofill handle? No answer. No help.
Here is the solution:
  1. Click on the Microsoft Office button in your Excel program
  2. Select Options
  3. From the new window that opens, select 'advanced' on the left-hand side
  4. Select the check-box 'Enable fill handle and cell drag-and-drop' on the right hand side.
  5. Click OK
    You can watch the Excel training video below to learn how to get back the autofill handle in Microsoft Excel:




Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010