Where is my autofill handle

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:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.