To highlight cells that are not next to each other:
- Highlight one set of cells
- Hold down CTRL
- Highlight the other cells you want (Keep CTRL held down)
- Let go of CTRL
- Now both sets of cells that you wanted, are highlighted and can be used.
To highlight cells that are not next to each other: