In most software, such as Word, the only
difference between 'copying' and 'moving'
is that when you move something the original
is deleted. When copying the original
is left as it was. In Excel there is a
significant difference.
The mechanics of copying are similar
to those for moving, except that:
- if you use the drag and drop method
you must hold the ‘Ctrl’ key down throughout
the copy operation
- if you use the submenu you use Copy
and Paste instead of Cut and Paste
The difference is that when you 'move'
the addresses in the formula change so
that they are at the same relative position.
The example below illustrates this:
