If you want to move a cell or a range, you can use various methods:
METHOD 1
Select the range you want to move, Ive 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:
