Forum Discussion
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...
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
I have the same problem, but the Inquire/Clean Excess Cell Formatting doesn't help. Can't see anything from D42 down, nor F42 down. But if you select E25 and double click to fill down (only wanting to go thru row 41), it will autofill down to row 2001. ?