A cell (and any contents that it contains) can be moved by clicking
The procedure requires you to:
When you drag to a new location, you must hold the left mouse button down. Don't let go until you arrive at the new location for the cell.
Cursor is a White Cross
|
Cursor is a Black Cross with
Arrows Pointing in Different Directions |
A cell (and any contents that it contains) can be copied by clicking and dragging the border of the cell in much the same way as when moving a cell. However there is one small difference. You must also hold down the CTRL key on your keyboard (bottom left corner of keyboard) as well.
The procedure requires you to:
This procedure may seem complicate but is not. When practised, it is the fastest way to copy cells to a new location.
Please note that holding down the CTRL key on your keyboard changes the mouse cursor. Instead of a black cross with arrows pointing in different directions, you will see a white arrow with a tiny + next to it.
Cursor is a White Cross |
Cursor is a White Arrow with Tiny + |
Try this a few times to practise? Download the practise spreadsheet with coloured cells