Question 16What is the difference between copying and moving a range ?

Question

Accepted Answer

Copying a RangeMoving a RangeWhen we copy a range of cells, we create a duplicate copy of the selected cells.When we move a range of cells, we are relocating the selected cells from their original location to a new location.The original cells remain at their original location, and a copy is placed elsewhere in the worksheet.The original cells are deleted from their original position and placed at the new location.This is useful when we want to preserve the original data while using a copy for calculations, analysis, or other purposes.This is useful when we want to reorganize our data within the same worksheet or between worksheets.

Copying a Range	Moving a Range
When we copy a range of cells, we create a duplicate copy of the selected cells.	When we move a range of cells, we are relocating the selected cells from their original location to a new location.
The original cells remain at their original location, and a copy is placed elsewhere in the worksheet.	The original cells are deleted from their original position and placed at the new location.
This is useful when we want to preserve the original data while using a copy for calculations, analysis, or other purposes.	This is useful when we want to reorganize our data within the same worksheet or between worksheets.

Spreadsheet Tool : OO Calc I — Question 15

Question 16