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]
It is quite clear this issue has gone dead. It has been almost a year since anyone has even looked at it. What's the point in voting? What the heck are we voting for if no one responds?
Robert Zink commented
Anything, Microsoft? Please update us!!!
Bring it back. Nothing else works as easy.
Successfully downgraded to Office 2011 - 3 weeks ago - all behaviours are back just fine. Macros work (half as many dire warnings), keyboard customizations, relative references, formulas copy and paste, click to add cells, printing on custom size papers works, no freeze-ups (so far).
I don't collaborate online, and I write and use all my own macros in-house. YMMV.
Total waste of space remobving it - it's pants compared to the old version
Refik Telhan commented
I really do not understand why such a handy feature has been removed in the first place. There may be good reason to remove it, but it could still have been kept in the software with a modifier key. Why removing it totally?
This is one of the many features I am missing from Excel 2011. The colour palettes have changed, the Developer UI is now inconsistent with years of previous work. I can't touch those sheets with the new Office. Many keyboard shortcuts are gone. I see my windows user colleagues reaching for the mouse all the time to paw through oceans of ribbons. Now I know why.
At the same time, some devilish new feature that slowly misaligns my cursor from the spreadheet cell below is a new plague. I find that for all the 365 office apps, I have to wait for each command to complete before the next can be entered. For example command-s, command-w. I moved to 365 when getting a new computer. My 6-year old mac was faster than Office 365 on a six core i9.
I would welcome a mode that let me use the old colours and keyboard shortcuts. Yes, and the click to sum behaviour too.
M. Turner commented
Please bring this feature back!!
Dear Steve, your last update was in late March, it's now October - has there been any progress? Can this be incorporated as a user preference?
please restore the simple click function to sum randomly selected cells.
Please, Pretty Please. as cmd or option click would be acceptable, and while you are at it how about bringing back the option click on a row or column to insert a new one quickly. Thansks for listening.
This is the NUMBER ONE feature that I most use. It is so basic and simple. Now, one has to go around the block to get next door. PLEASE REINSTATE this key function!
Bring it back!
bring back, please!!!
Niles B commented
Please bring this feature back!!!!!!!
How many requests does it take to get this done???? BRING THE FEATURE BACK!
I still miss it constantly after several years. Bringing it back as an option set in preferences would be fine. One of the preferences could be set is that you need to press the Option Key while clicking to get the sum. This would compliment the feature that holding down the Command Key while clicking on cells creates a list of cells separated by commas.
PLEASE BRING IT BACK.
I support enabling a preference to get this feature back. Please!!!
Paul Connelly commented
Enabling a preference would work.
Alternatively, holding down another key (like CMD) while clicking on the cells would be acceptable.
But it's not acceptable to withhold this capability from Excel 2016. Will seriously consider my alternatives. I'd been using Excel 2011 till yesterday and am shocked at the lack of this feature in Excel 2016.