If you want to move a cell or a range,
you can use various methods:
METHOD
1
Select the range you want to move,
I’ve chosen a range consisting
of just one cell ‘D5’.
Move the cursor to the cell and
when it changes from a cross to
an arrow
you can drag the range to the desired
location:
Note that after the move the formula
is still the same:
=C3 + D3
Click
the Button to Play >
METHOD
2
Select the range you want to
move
Right click to get the submenu
and select ‘Cut’
Select the destination cell (left
click)
Right click to get the submenu
and paste
Notice that whenever you move something
the formulae, and hence the values, do
not change. You can always move things
around freely to get your spreadsheet
looking the way you want it.
you can drag the range to the desired
location:
