A more efficient way to sum column
Hi there guys,
Let's say I have a simple column with numerical values (check figure A attached).
If I look at the right bottom corner of the Excel window, I'll get a quick summary of the data (average, count, sum).
Oftentimes, I'll need to use this sum elsewhere (sometimes beyond Excel). Thus, I've always wondered why there is no shortcut to simply copy the sum to clipboard.
I understand that I can use something like Autosum to calculate it quickly but I feel this would be an even faster and more efficient way. And that's sort of the point of Excel, right? To make us more productive.
When working with large data (hundreds of columns, and thousands of rows) I would really prefer not to disrupt the data (or maybe I'm too lazy trying to find a free cell to use Autosum) but just get the sum copied to my clipboard. And to be honest, I've consistently met people wondering the same thing wherever I worked.
Thank you!
Best
1 comment

Roy commented
Or I don't want a summing cell for the data I selected. Just want to highlight a bit of it and see what those cells sum to. Sheesh. MS... c'mon!
In any case being able to click there, select copy, and paste somewhere, anywhere else, would be super nice.