Forum Discussion
SUM!?
I'm also not a Mac user. Base on this thread Just click individual cells to sum in Excel (microsoft.com) such functionality on Mac disappeared with introduction of 2016.
Thank you for your prompt response, Juliano.
Unfortunately, what you are suggesting is what I am trying to avoid. I've never had to do such in years of Excel use. I want to insert "=" and then click on each cell above, independent of one another. Each cell should highlight in its own color. Once I click "return," all the above highlighted cells give me the sum.
There must be a setting for this, but where???
Excel needs some delimiter to separate the range as you click in different cells.
If you just type "=" and start to click, excel will "understand" that the last clicked cell is the cell you want to refer.
Even with delimiter you need to tell to excel what operation or action you want.
There is only one way (without vba) you can achieve it. But for me takes more time than just typing a formula
Because you will need extra clicks by coming and going between "box numbers" on each click of the cell.