View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Turn off auto sequence in fill down?

On Aug 4, 8:27*am, Mike H wrote:
Hi,

2 ways

Enter E76D3456-1 in the top cell then select that cell and the range to fill
then
Edit|Fill|Down

or
Enter E76D3456-1 in the top 2 cells and select them both and drag down with
the fill handle.

Mike



"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- Hide quoted text -


- Show quoted text -


Thanks to both Mike & John for their help.

Pierre