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.
I have great news to share. In the latest Insiders Fast release, we’ve added a preference to enable this feature. If you’re an Insider and you’ve chosen the Fast updates, just install version 16.37 (200413) or greater, then go to Preferences > Edit > and Enable Click to Add Mode. Then you can type = and click cells to create a formula that adds the cells together.
This feature should be released to everyone in May 2020 (v16.37 or greater). If you’d like to become an Insider, just go to the Help menu, choose Check for Updates, then click Advanced and opt into the Insiders program. Choose the Fast updates.
Hello Excel Team,
Pls add back the auto plus function. I think, it is better to keep the option open rather than taking it off without taking vote for that and now asking for several thousand votes!
This function was the most used by me in the old version. It's a big problem now its gone. Please bring it back.
Please do bring this back. It would be fine to enable a preference to get the old behavior. That's easy enough. This feature had been one of the few things that I used on a daily basis that made an Excel a better product than Google's competing spreadsheet application. Now I'm wondering if that competitor has a simpler workaround than the onerous "=sum( command-clicking cells" mentioned above. Thank you to Saskia Aldershof for bringing this to MS' attention, and all of you commenters who are continuing to push to bring this back.
Please bring back this useful feature! The new method is such a nuisance and a feature I have always hated on my PC at work. The loss of this feature is a step back. Think of adding it to the PC version rather than removing it from the Mac version.
Oh PLEASE bring this back! I use it daily and hate when I have to use 2016.
Yeah, this was one of the most useful tricks in XL. Saved a ton of typing.
I upgraded to 2019 for Mac and am annoyed by the removal of the previous ability to click '=' and then click selected cells to add them all. Please add a preference or return this functionality.
I'm with everyone else here. Taking away a fundamental user interface feature that we've all learned to use for so many years, is bound to be a negative experience. Please give Mac+Win a preference option, or add control-click feature, or something.
I was also really surprised Microsoft would make it harder to add specified cells by just typing = and clicking on the cells you want to add up. Having to key in '+' for each cell made it a much longer process and one that I do often - 20 extra steps for a list of 10 numbers!
However, I now realise I can just use the autosum function and hold down the cmd key while I click on the cells I want to add - almost as easy I think.
I've just deleted my comment about being able to use this function on the update just received from Microsoft. I can't reproduce it this evening, although it was working yesterday. I do not have the older 2011 version installed on my laptop, and was definitely using the latest Excel. I simply can't explain how this feature worked yesterday. All I know is that it doesn't work today, so I'm back to the same very frustrating Excel experience I had grown used to. Apologies to all who got their hopes up!
Just updated to 16.16.5 not fixed and not in any preferences option.
I am using Excel 2019 and just updated with "Office Insider Fast" and the feature is still missing.
Frustrating non action by Microsoft and a downright dumb excuse by Steve K., who probably stopped reading this or has no pull at Microsoft.
Maybe already fired.
NOBODY EVER requested that this feature be removed. If that is stated it is a LIE!
People who used it just would and users who didn't just didn't.(Or, may not have known about the convenience)
Certainly no compelling reason to remove it.
Back to 2011for me also, no updates or security risk is accepted.
Just an update to my October 17 posting.
We are still reverted to Microsoft office Excel 2011, and it’s going great! So far the bogeyman has not infected my computer and Excel is working as it should!
I hear that the 2019 version is no better than the 2016 version.
Also, Steve has not commented since March of this year. So that update is pretty stale.
What a weak update comment from Mr Steve K on the Excel Team. We all know you can easily create an option in the Preferences to have this operate the "old" way or the "new" way. The arrogance of Microsoft never ceases to amaze. A great example of this arrogance and lack of true listening to consumers is The Ford Sync fiasco: Microsoft failed to even listen to their customer Ford and ended up losing the entire business allowing their competitor to step in and thrive by providing a useable fun product. Get with the program Steve!
Good grief, man, it's been over 3 years! Is it not time you start listening to your users?
yes. I want the simple "click to add " back too.
Well, to all and sundry.
Patience has worn thin. Tension high. Nerves frayed. Can no longer "make do" with the lack of "click cell addition" AND the issues of incredible slow calc, slow cursor and cell transition, etc.
2016 was removed 20 minutes ago. yes, 2016, gone, deleted. And Excel 2011 has returned.
The number of issues are shocking. And my maxed out, late 2016 MBP is not a slow machine....
just noticed this basic functionality (i wouldn't even call it a feature) missing after an "upgrade". i also vote to bring it back. i'd be perfectly fine with having to enable a preference.