Dec 05 2020 11:10 PM
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..
Dec 06 2020 01:41 AM
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.