Feb 22 2021 09:31 AM
Hello
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 ?
Feb 22 2021 09:36 AM
@PleaseAnswer1703 That happens to me sometimes. Just hover over the right-hand bottom corner of the cell. Right-click and just drag.
Feb 23 2021 12:24 AM
@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 ?
Feb 23 2021 12:35 AM
@PleaseAnswer1703 Then check this. Perhaps, "Enable Fill handle....." is not switched on.
File, Options, Advanced.
Feb 23 2021 01:10 AM
@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 !