what is the difference between copying and moving cell range
Answers
Explanation:
The Difference Between the Move & Copy Commands. Chron.com Copying a file, folder or piece of content means duplicating it. ... The associated keyboard shortcuts are "Ctrl+C" (or "Command+C" on a Mac) to copy whatever is selected and "Ctrl+V" ("Command+V") to paste it into a new location.
Answer:
Copy leaves the information in its original location and makes another copy of the information when you use Paste. But in moving it removes the information and pastes it to another location.
Usually, in computer science, "moving" is equivalent to "copying" something, then deleting the original. In other words, after copying something, you have two copies of the thing you copy; if you move something, only one, at the new place. However, specifically in Excel (and probably other spreadsheet programs as well), when you move a cell or a range, any formulae that refer to the cell (or to one of the cells in the range) will be updated; thus, in this sense, moving is no longer equivalent to "copy, then delete the original". For example: Cell B1 has the formula "=A1*10". If you move the contents of cell A1 to A5 (you can do this in several ways; one is by selecting the cell, and dragging the border), then the formula in B1 will change to "=A5*10".