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.
Image result for microsoft excel not working

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.
Excel Fill Handle Not Working Properly Excel Fill Handle Not Working Properly Reviewed by TechnoWala on August 12, 2019 Rating: 5

1 comment:

Powered by Blogger.