What is the difference between clearing and deleting?

If you clear the contents of a cell the contents are removed but the cell remains (empty). If you delete a cell the cell and its contents are removed. Adjacent cells will be moved to fill the space

How do I clear the contents of a cell/cells?

1. Select the cell(s) you wish to clear.
2. Press <Delete>.

How do I delete a cell and its contents?

1. Select the cell/cell range that you wish to delete.
2. Right click.
3. Click ‘Delete’.
   The ‘Delete’ dialogue box will be displayed as shown opposite.
4. Choose whether to delete the entire row or column, or, if deleting a cell whether to shift the remaining cells left or up.
5. Click ‘OK’.

The cell(s) selected will be deleted and adjacent cells will be moved to fill the space created. The illustrations opposite show the result of deleting the cell A5-A8 and shifting the remaining cells up.