# How can I prevent Calc from automatically selecting all the cells above a function? Excel is so easy, you just hold the Ctrl key and select any cells, even non-contiguous cells. Calc's auto selection is driving me crazy! [closed]

Let's say you have a column of 10 cells (Rows 1-10) and you want to find the sum. You click cell 11 (where you want to display the sum) and hit the SUM (sigma) radio button. Calc will automatically highlight all 10 entries in the cells above. That's fine if you want to sum ALL of the cells. But what if you want to sum only 8 of the 10 and perhaps they are not all contiguous? I cannot figure out how to just include the desired cells! Excel is so very easy. You just hold the CTRL key down and click on each cell that you want to include in the sum. No gymnastics..it just works and so simple. Why can't Libre Calc do this? What am I missing?