R
Richard
I tried ctrl drag and got nothing. I could have typed them in by now but I would learn nothing THX!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi Richard
not sure what you're trying to achieve or what your issue is. Could you
explain with some more detail?
not sure what you're trying to achieve or what your issue is. Could you
explain with some more detail?
J
Jim Rech
Drag the "fill handle" (the little square in the lower right of the cell
selector). If you don't see it, make sure Tools, Options, Edit, Allow Cell
Drag and Drop is selected.
selector). If you don't see it, make sure Tools, Options, Edit, Allow Cell
Drag and Drop is selected.
G
Gord Dibben
Richard
Method 1. Enter 1 in A1, 2 in A2 then select both cells drag/copy down using
the fill handle(right-bottom corner of cell).
Method 2. Enter a 1 in A1 then right-click and drag down. Release button and
"Fill Series".
In both cases, be sure you have Tools>Options>Edit "allow cell drag and drop"
checkmarked.
Gord Dibben Excel MVP
Method 1. Enter 1 in A1, 2 in A2 then select both cells drag/copy down using
the fill handle(right-bottom corner of cell).
Method 2. Enter a 1 in A1 then right-click and drag down. Release button and
"Fill Series".
In both cases, be sure you have Tools>Options>Edit "allow cell drag and drop"
checkmarked.
Gord Dibben Excel MVP