Forum Discussion

Copper Contributor

Feb 22, 2021

Problem DRAGGING CELLS

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 ?

excel

Riny_van_Eekelen

Platinum Contributor

Feb 22, 2021

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

PleaseAnswer1703
Copper Contributor
Feb 23, 2021
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 ?
- Riny_van_Eekelen
  Platinum Contributor
  Feb 23, 2021
  PleaseAnswer1703 Then check this. Perhaps, "Enable Fill handle....." is not switched on.
  
  File, Options, Advanced.
  - PleaseAnswer1703
    Copper Contributor
    Feb 23, 2021
    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 !