Turn off auto sequence in fill down?
If you rightclick and drag that little fill handle, you can choose how you want
the cells filled.
I think that's easier than remembering how excel fills the data.
Pierre wrote:
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
--
Dave Peterson
|