Forum Discussion
Can no longer drag my mouse to expand a selection
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.
SergioDCQ The dot (bottom corner of the selection) is at the bottom left corner of A5. This is what it looks like if you have the entire row selected.
There is a distinction between expanding your selection and dragging that dot (known as the "fill handle").
Dragging the fill handle will copy the cells in the selection to the area where you drag and release.
Expanding your selection does not require the fill handle. You can simply click anywhere, hold the mouse button down, and drag to expand your selection. If you already have more than one cell selected, you can hold down the Shift key and then click-drag with your mouse to expand the selection.
- Ok, but what happened to the "fill handle"?
It was always there before.As Steve_SumProductCom suggested, when you select an entire row, you'll find the fill handle in the bottom left corner of the first cell of the selected row(s).
