From The Document Foundation Wiki
    < Faq‎ | Calc

    How to select two cells that are not adjacent

    When you click on a cell, it is not selected, but only highlighted.

    To actually select a cell:

    1. Hold down the ⇧ Shift key and click on the cell
    2. After doing this, you can select non-adjacent cells by holding down the CTRL key.