Forum Discussion

baren20's avatar
baren20
Copper Contributor
Dec 06, 2020

In excel Cursor not converting..

From today i am not able to drag the cursor of excel from cell to cell. I can only select the cells but dragging option is not coming for sum or applied formula to all cells through pressing down right corner of single cell. 

 i have attached the picture to understand the area.

 

please help me..

1 Reply

  • baren20 

    Select File > Options.

    Select Advanced in the navigation pane on the left hand side.

    Under 'Editing options', tick the check box 'Enable fill handle and cell drag-and-drop'.

    Click OK.

     

    ā€ƒ

Resources