| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop the screen from 'flashing' when copying and pasting | Excel Discussion (Misc queries) | |||
| Intelligent lookup of a suburb | New Users to Excel | |||
| Intelligent VLOOKUP | Excel Worksheet Functions | |||
| how to stop someone from copying my protected files | Excel Discussion (Misc queries) | |||
| How do I stop automatically copying an entry to the next column? | Excel Discussion (Misc queries) | |||
Linear Mode
