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
Alternatively you can 'cut and
paste':
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
again and left clck on the 'Paste
Option' icon
Roll your
mouse over the image to see
the paste operation.
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:
