Forum Discussion
AutoFill Handle Double Click Filling Too Far
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 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.
Erin,
In fact, I didn't find the reason for this issue!
The area around the data is totally blank!
But I've done this, and the problem disappeared!
Hope that helps
Haytham
Thanks, I had tried deleting the rows but not the columns to the right. Apparently that makes a difference.
Hi Erin,
Your cells under the bottom of the data are not clean (you may check by Ctrl+End). I made Inquire->Clean Excess Cells Formatting, after that autofill works correctly.
Thanks for this. Do you know if there is any way to see in Excel what this formatting is that it is cleaning up? I am curious what is putting it there so that I can adjust as necessary so it won't be there in the first place.
Thanks,
Erin
Hi Erin,
I'm not sure how to recognize that visually. It happens if you have some data, especially in formatted columns, after that remove them. More about that is here
https://support.microsoft.com/en-gb/help/244435/how-to-reset-the-last-cell-in-excel
