Problem DRAGGING CELLS

%3CLINGO-SUB%20id%3D%22lingo-sub-2156299%22%20slang%3D%22en-US%22%3EProblem%20DRAGGING%20CELLS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2156299%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIssue%3C%2FSTRONG%3E%20%3A%20I%20want%20to%20use%20cell%20dragging%20to%20extend%20a%20range%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem%3C%2FSTRONG%3E%20%3A%20My%20cursor%2C%20when%20hovering%20over%20the%20corner%20of%20the%20cell%2C%20won't%20change%20into%20%22drag%22%20mode%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20any%20ideas%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2156299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 ?

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!