Frequently asked questions - Calc
From The Document Foundation Wiki
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:
- Hold down the ⇧ Shift key and click on the cell
- After doing this, you can select non-adjacent cells by holding down the CTRL key.