New Contributor



Issue : I want to use cell dragging to extend a range

Problem : My cursor, when hovering over the corner of the cell, won't change into "drag" mode


Has anyone any ideas ?

5 Replies

@PleaseAnswer1703 That happens to me sometimes. Just hover over the right-hand bottom corner of the cell. Right-click and just drag.

@Riny_van_Eekelen Thank you for your response. This doesn't work. Hovering exactly over the right corner of the cell and right clicking either a) brings up in-cell menu ( as expected ), or if slightly off target b) highlights the cell to the right.


So this doesn't work, but thank you for your reply.


Anyone else can help ?

@PleaseAnswer1703 Then check this. Perhaps, "Enable Fill handle....." is not switched on.


File, Options, Advanced.

Screenshot 2021-02-23 at 09.30.38.png

@Riny_van_Eekelen YOU LEGEND !! 


This is the perfect solution ! I had no idea this could be toggled on/ off. Please know that you taking the time to provide this solution is going to seriously save me a lot of time.


Thank you ever so much !

@PleaseAnswer1703 Glad to help!