Stop the 'intelligent' copying?

  • Thread starter Thread starter Terry Pinnell
  • Start date Start date
T

Terry Pinnell

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'!
 
Hi Terry

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

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

HTH
Martin
 
Back
Top