Microsoft Excel Fill Handle Not Working Properly
Well, there is no any particular reason behind Excel Fill handle not working issue. So, here we have tried some of the possible working solutions.
Method 1: Remove Filters
Well, if you have added filters then this makes the fill handle to cause an issue. So, many users state that removing filters from the columns in your Excel workbook solve the issue.
After removing the filters the fill handle began working again.
Therefore it is worth to check if you had added column filters than removing and check whether the fill handle not working issue is solved or not.
However, if you are still facing the error then follow the second solution to solve the issue
Method 2: Tick Mark Automatic in Formulas Tab
Checking Automatic in Formulas tab resolve Excel Fill Handle not working properly issue for many users.
So here know how to do so:
- Go to the ‘Formulas’ tab
- And then go to the ‘Calculation Options’ from the drop-down menu
- Make sure ‘Automatic’ is checked.
Hope this work in your case but if not then here is another trick.
Comments