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.
I would really like to see this added back.
Why would Microsoft do this kind of damage to Excel? I do not need to spend my day typing + signs. I want my money back.
User of Excel 365 for Mac and I would really like to see this added back. I think a preference ability to revert to the old behavior would be preferable.
Please add this function back. It is critical to all I do.
Wow! If I could roll back, I would, but my old software doesn't work with the newly installed iOS. Sheesh. Who thought removing this feature was a good idea? Clearly, someone who doesn't use spreadsheets. I can't believe this didn't come up in UAT with business users!
Why did you get rid of this function it was one of the very few things that kept me from switching completely over to Google Sheets.
Please, please, please add the function back. Have just upgraded to latest version from 2015 and discovered its missing so reverted to older version as latest is a functional down grade rather than having any advantage.
Bring it back as a preference. Very useful and ergonomic for certain very common work situations.
Add my vote for a preference to select either the new (problematic) behaviour, or the old (it wasn't broken so why was it fixed).
Charlie Hartman commented
Adding this functionality back as a preference should mean making it something you can choose to have turned on or not. It should be a one-time choice, and from then on you'd be able to click on cells to add them.
I like the add-as-i-click-cells and sometimes i dont based on what i'm trying to do within the sheet. So having it as an option is great. It can be a Preferences but changing this option would take too long by leaving the sheet and opening the Preference window. It takes too many steps vs holding down CMD or Option or Shift or Control.
Please bring this functionality back. I think adding as a Preference would be the best solution.
Kiyoshi Inoue commented
I am really struggling with the new catalina update for mac as it forced me to update to the latest office package. I combine information from multiple sheets with intricate structure, adding individual cells in different location on each sheet. Being able to click to add in each cell after inserting = in my totals sheet in imperative.. I can't fathom why this feature is no more?!!???? I guess I could work with the cmd suggestion but as excel has no feature that conflicts with this simple yet ingenious feature is mind puzzling..
Denise Imbesi commented
This was one of the best features of Excel which in my opinion sets Excel apart from other worksheet programs. Please please bring it back...
Absolutely bring that function back. It was such a time saver! Thank you
Please bring that function back. I just upgraded and now takes me so much longer to do my spreadsheets and I hate it. That feature was extremely convenient. I also use a mac.
I am a 100% Mac user and I too want to see the function back.
Why make Excel more consistent between Mac & Windows? The reason I have a Mac is to never touch a PC of my whole life again.
BTW, why do I have to pay 70$/yr for MS on my Mac? I had MS Office 2011 for years. Now we have to pay a fee yearly? Such a rip off!
Geoff Berlin commented
Yes, pls add this feature back. I just "upgraded" from Office 2011 for Mac to Office 365, and it's not there. Looked through Preferences and could find no way to activate. Pls add it back!
I am a Mac user and I agree with all the comments re the need to click + between clicking cells I want to add together. Not only is it a retrograde step it is inconvenient with the + key being on the right of the keyboard. I also have clients who are very unhappy about this. I am seriously considering cancelling my subscription and looking at other options than 365.