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:
- Click on the Microsoft Office button in your Excel program
- Select Options
- From the new window that opens, select ‘advanced’ on the left-hand side
- Select the check-box ‘Enable fill handle and cell drag-and-drop’ on the right hand side.
- Click OK
You can watch the Excel training video below to learn how to get back the autofill handle in Microsoft Excel: