Stop the 'intelligent' copying?

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'!
 
R

Roger Govier

Hi Terry

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

MartinW

Hi Terry,

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

HTH
Martin
 
Top