Just click individual cells to sum
Excel 2011 had the possibility to sum individual cells by typing "=", and then just clicking on individual cells across the workbook that you want to sum, and "return" when done. This functionality is no longer available in Excel 2016 (you have to type "=sum(", then clicking on the individual cells while holding down the command key, "return". I would be happy if the old functionality is brought to Excel 2016.
Update – thanks for the continued support of this feature. We’ll keep this request open for voting, but we’ll need to consider modifying the behavior slightly if it is to be brought back. For this suggestion, we would want to enable such behavior on both Mac and Windows, but we would need to do it in a way that does not cause problems for people who don’t want this behavior. For example, it may be that you would type =, then hold the CMD key as you click the cells to be added. Or perhaps you would need to enable a preference to get the old behavior. Please comment on these options or offer other ideas.
We’ve been working to make Excel more consistent between Mac and Windows, as can be seen by the updates over the past several months, which have satisfied several thousand votes on this forum (multi-thread calculation, PivotCharts, modern chart types, new functions, slicers for tables). I mention that to be clear that we are listening to the suggestions, comments and votes.
Steve K [MS Excel]
I looked into this, and of course you are right - we changed the behavior in Excel 2016.
The reason we did that was for consistency with Windows Excel, so voting here is a great way to bring this change to the attention of the team.
I'll take a look at previous versions of Excel - I didn't realize that you could just "click" around before. I will note that even if you could do this in Mac Excel 2011, we're moving more and more to have a common user model between Mac and Windows Excel, so we still may not bring this back.
YES PLEASE BRING THIS BACK!!!!! i don't want to have to use the keyboard to do basic addition of multiple cells!
Saskia Aldershof commented
Hello Dan, that is what I wrote, but it was so much easier before...
Dan Battagin [MS XL] commented
This still works in Excel 2016 - after you type =SUM(, holding down the command key and clicking on the cells you want to sum is exactly the way to get multiple cells summed up!