Forum Discussion
How to Get Excel to Automatically Insert plus/addition sign
I read the above answer , and it makes absolutely no sense, What so ever.
Why, was it once automatic to have the + sign added when clicking on multiple cells, and now it is not - (who's brilliant idea was it to screw up such a basic and essential function of Excel?) and how in the H. does one re-implement it - in plane and simple language- not 15 different steps - Really folks, why can't this be simple?
As a simple user like you, I can only recommend giving feedback or suggestions to Excel if suggestions and/or changes are to be made or desired.
Some information about it.
How do I give feedback on Microsoft 365?
Thank you for your understanding and time
Hi NikolinoDE ,
Like my earlier comment, obscurity seems to be the name of the game here.
I am of course giving feedback and making a suggestion.
Specifically, Please don't make systems so obscure, and not intuitive. More specifically; What is the simple way to add a plus sign after each reference clicked on like like Excel use to do? Is it just a preferences change due to a new version of excel, or a feature change? I may not be an Einstein, but after spending a small bit of time the simple answer to this simple question is not showing up. I'll keep looking, but such a basic and useful function shouldn't be so hard to find.
Thanks!
- Does anyone else know the answer to this simple question?
It is driving me a bit nuts, after just searching again all the online forums I could find with no luck.
I am dearly hoping that the setting to return this feature is buried in a settings page somewhere and has not become a "Depreciated" function.
But if anyone knows please say!
Thanks.If I am understanding right you want to be able to quickly add and subtract cells with simple clicks right?
If so (sorry if not) Here is how you can set it up:
Select the cell you want the totalled sum to be added to
Then in the formula area:
Type in the following =SUM(
Then simply click the cell you wish to start with, then pressing the Ctrl key click and additional cells you wish to add:
Then click back in the formula line above and add ")" at the end of the cells:
And then click anywhere on the spreadsheet to finalise that formula. That will add those together in that original cell you picked for the sum:
Note: clicking back on the sum cell will make it so you can see that formula used.
If you are wanting to subtract you can do it his way.
Select the cell you want the total to be in and then in the formula area type "=" :
Then you type this formula:
And, like before, click the first one you want to subtract from that total, then holding Ctrl click any others you want to subtract and add the ")" at the end:
And this is the final result of that:
Hope this helps, sorry again if it's not what you needed or you no longer need it!
- NikolinoDE , I might add, if you had the time to send what looked like a slight reprimand to my frustrated comments, you could have just answered my question.
Do you understand my question ?
If so, what do you know about the answer?
