Forum Discussion
Can no longer drag my mouse to expand a selection
Not sure what the move is called, but I can no longer click on a selection in Excel and expand that selection. Open a blank sheet, select A1, and there's that little dot in the bottom right corne...
I don't know about Mac, but in Windows it has never been possible to drag the 'fill handle' to the right and down at the same time - one can only drag it to the right, then drag it down, or vice versa.
To display the fill handle: select Preferences from the Excel menu at the top.
Select Edit.
Tick the check box 'Allow fill handle and cell drag-and-drop' in the Edit Options section.
I just checked and that box is selected.
I know for a fact, I could do it for rows. I can no longer do it and have no idea what has happened
I know for a fact, I could do it for rows. I can no longer do it and have no idea what has happened