Problem DRAGGING CELLS

[PleaseAnswer1703]

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 ?

[#2]

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

[#3]

@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 ?

[#4]

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

File, Options, Advanced.

[#5]

@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 !

[#6]

@PleaseAnswer1703 Glad to help!