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...
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.
Haytham Amairah
Mar 20, 2018Silver Contributor
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
- Erin SimmonsMar 21, 2018Copper Contributor
Thanks, I had tried deleting the rows but not the columns to the right. Apparently that makes a difference.