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]
My guess is that this purported voting, or discussion, is really just a notification that this feature will not be reinstated. Over four years now = dead.
Time to move on; I reverted to 2011 for sheets that needed to stay with Excel, and I’m learning to cope with Apple’s Numbers app. All my new sheets will be with Numbers, as MS has clearly shown antipathy to Macs.
Looks like they already said they would not bring this feature back. (defies logic and are there really users who would not like it?)
But, kept open for voting, which is weird.
Also, Mac and Windows users have been working with different UIs for umpteen years.
Don't see why it needs to be uniform, if it kills features both platforms would like
March 28, 2018
DECLINED · ADMIN Excel Team [MSFT] (Product Owner, Office.com) responded · March 26, 2018
Thanks for all your comments and votes supporting this suggestion. We are not planning to bring this feature back. As mentioned, the workaround is to type =SUM() and then hold the CMD key when you click on the cell references.
Steve K [MS Excel]
Echo others' comments, please let us know one way or the other, hopefully you'll bring this feature back. But please communicate with us!
Dear Steve K., I venture to guess that not a single user would object to this feature being added as a user preference. Restoring this has been debated since 2015. If Microsoft has no intention of honoring this request, please, just say so. Here, allow me to help, "Dear Excel users, we have gratuitously let this thread live on for years now, and while we enjoy seeing you hopelessly beg, please know you can direct this request to the nearest brick wall. Sincerely, Microsoft."
I truly hope, however, Microsoft will implement this as a user option and be done with it – and bring a smile to your customers' aging faces. Thank you.
Yes, the old way is easy and intuitive. I have noticed MS seems to regularly delete great features in Office every time they "updgrade" the software (like autorestore in Outlook, photo editing and viewing functionality, the "delete" email option embedded in Outlook email alerts, etc.) . If you already wrote a great feature, why does MS delete its functionality? It should cost nothing to leave the code in there that you already paid for. Very frustrating MS habit. Sometimes older is definitely better and its why I am slow to update MS software.
bring it back. bring it back. bring it back.
Steve Treichler commented
YES!! Bring back the old feature - or at least make it an option, or use CMD key or WHATEVER. Why, or WHY did it get taken away?
Totally agree... why they would remove this simple and quick method to add cells is beyond me. It is adding so much time on all of my calculations now that it's impossible. Interestingly, Numbers on a mac has the feature... so after years of using excel on my mac, I will try to downgrade or have to switch to numbers... what is wrong with Microsoft!? listen to your customers!
STEF BUTLER commented
This was a great feature for YEARS. Please bring it back. No reason to not.
Gary Rosner commented
Why not make this an Excel Option on the Formula's panel?
Looks like MS is not listening at all.
What puzzles me is that anybody considered this not a worthwhile user-friendly feature.
Plus, Mac users and PC users all know how to run their versions (and have for years), no problem any place.
If anything this feature should be added to windows version if it didn't exist there.
As with functions in other programs of the 2011 Suite, I fail to understand how something so simple, yet efficient is one, dropped from a newer version, and two, despite seemingly overwhelming support is still not corrected/returned.....I feel as if the road is running out.
On one hand, I must gradually update the OS, and when I do, at some point, the 2011 MS Suite for Mac will cease to be compatible. And then I will be FORCED to move to a less capable, less user friendly software. This is somewhat akin to having the car dealership take my 2011 car and force me to purchase a Model T......
I would challenge MS to, if the belief is that they have somehow included an equally efficient option, to then explain to us what exactly is the comparable operation . . . .
"Or perhaps you would need to enable a preference to get the old behavior." - Great idea! Please bring it back!
Attention Microsoft Excel team. This discussion has been going on since September 2015 and there was a note from a Team member on March 28, 2018. Can anyone there confirm that you folks are watching this thread?
Users are not only asking for this function, but they are stunned and astonished that you removed it in the first place!
We'd like it back! If you want to make it an option, fine. What's the issue on your end?
OMG! How could you remove this function? I held off for as long as I could to switch from Office 2008 a more current version (Office 2019 for Mac) and now I know why! You remove a function like this that is used constantly by everyday people, as demonstrated by the comments below. Thousands if not millions of others haven't gone online to complain like we are but trust me, they are out there. PUT BACK THIS FUNCTION. It's a horrible oversight on the part of Microsoft. If it doesn't return then I'm going to switch over to Pages on my MacBook Pro.
I miss this function, which I used to use on both mac and pc
Please bring back the old functionality of just being able to click on cells...very difficult to make this change after 30 years of the old version...
Yes, please bring it back
I agree with all the other commenters. Bring it back! Very annoying that it disappeared!
Marc Lemaitre commented
I also really miss this function! As someone posted last week > "Even if it were possible to add it back as a preference it would make my life so much easier (again)"
Please get it back.