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]
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.
Over three years have elapsed since the absence of this feature was noted, so I don’t expect that Microsoft will adopt this change. In addition the continuing existence of major bugs makes me deeply regret having upgraded to Office 2016. We are going to downgrade to Office 2011, and take our chances with malware on our own. That will be less troublesome than the damage and difficulties that we suffer almost daily!
I use Windows almost exclusively however I do have a Mac that I use occasionally and I can see how, without the use of a mouse, that this behavior needs to be returned to the Mac and even to give the option to use it in the Windows version now too.
The forced removal of this feature without an option to turn it on or off eludes me since there's still options for Lotus compatibility since Excel became a product and I don't see any effort to "force" Lotus users to use the Excel compatibility after all these years. Is Lotus even a product anymore?
Forcing Mac to Windows platform compatibility between two these two very mainstream products without on/off options doesn't seem to hold any logic...not while leaving Lotus options in the software. Does MS like Lotus users more than its Mac users?
We are now in September, i.e. almost 6 month without any action or comment from Microsoft.
IF it is true that there were users having an issue with this function making things easy, I'd like to ask why.
The minimum change that should be made is to allow it as a preference.
That way users who do not like this feature (Yeah right, not holding my breath for getting ONE good reason) can leave things as they are, but the users who use it can at least get it back.
As for making things uniform on Mac and Windows, not a big deal . We lived with differences all along and survived!
Please, please put the old functionality back in as a preference, it was a real time saver and easy to click between sheets, We would all really appreciate the option to toggle this on and off
many thanks in advance (hopefully)
Really, really miss the feature on Mac!
I would strongly like it back on mac
Charlie Yanjanin commented
enable a preference would be the easiest way to allow users to use their preferred method without learning a new key sequence,
This is the worst change to excel. Takes at least twice as long now to sum cells with the necessity to type in =sum( then hold down the command key to click all the cells you want to sum. Before you just typed in = and clicked on the cells you wanted and hit enter to sum them. Very unhappy with this change which was completely unnecessary.