G Guest Apr 28, 2004 #1 I tried ctrl drag and got nothing. I could have typed them in by now but I would learn nothing THX!
F Frank Kabel Apr 28, 2004 #2 Hi Richard not sure what you're trying to achieve or what your issue is. Could you explain with some more detail?
Hi Richard not sure what you're trying to achieve or what your issue is. Could you explain with some more detail?
J Jim Rech Apr 28, 2004 #3 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.
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.
G Gord Dibben Apr 28, 2004 #4 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
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
