Stop the 'intelligent' copying?
 

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

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

Stop the 'intelligent' copying?
 

Hi Terry,

When you drag, hold down Ctrl before you let go of the left mouse button.

HTH
Martin

"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