Turn off auto sequence in fill down?
Hi Pierre,
Drag down with the fill handle,
hold down Ctrl and then let go of the left button.
HTH
Martin
"Pierre" wrote in message
...
Want to fill down with the mouse without going to the next number in a
sequence;
IOW:
If A1 is E76D3456-1, I want to copy down using the mouse without
having E76D3456-1 turn into a "dash 2" in A2 but remain as
E76D3456-1.
Either double clicking in the lower right corner, or dragging from the
"plus sign".
I've looked through the tools/options, haven't found it yet. Ideas?
(Excel 2003)
TIA
Pierre
|