Forum Discussion
Erin Simmons
Mar 20, 2018Copper Contributor
AutoFill Handle Double Click Filling Too Far
When I highlight the cells I want to autofill down and double click the autofill handle, it fills past the last row of data on the left. I have verified through =ISBLANK() and even deleting the blank...
Haytham Amairah
Mar 20, 2018Silver Contributor
Erin,
Could you please provide us with the workbook itself?
The screenshots are not much helpful!
But I guess that there are some https://support.microsoft.com/en-us/help/823838/the-result-is-false-when-you-use-the-isblank-function-in-an-excel-spre in the worksheet.
Regards
Erin Simmons
Mar 20, 2018Copper Contributor
I have amended the original post to include the workbook. The issue is on the Master tab in copying down the formulas in O2:S2 via highlighting and double clicking the handle in the bottom right corner to autofill down.