View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Stop the 'intelligent' copying?

Hi Terry

Hold the right mouse button down as you drag the fill handle.
On release select Copy

--
Regards
Roger Govier

"Terry Pinnell" wrote in message
...
Could someone remind me how to stop (or temporarily override) this
annoying feature in Excel 2000 please? I simply want to be able to
copy text containing numbers, like a telephone number, down to the
following row by dragging it. I don't want '0845 600 8885' to become
'846 600 8885'. Or 'Call 0845 600 8885' to become 'Call 0845 600
8886'!

--
Terry, East Grinstead, UK