There is no way to select non-adjacent cells as in normal Excel.
In order to tot-up figures, it is useful to be able to use Ctrl+click and select different cells. There is no functionality in Excel online to do this currently.
We are excited to announce that it is now possible to select non-adjacent cells in Excel for the Web.
There are still several functionalities that are not available on non-adjacent cells, but the Excel team is working to add them.
Please continue to leave feedback to help us improve.
Makes Excel un-usable
Discovered this today, was going to move to all Office PWA's pinning them to my taskbar with my work's Office 365 subscription. Passing. Back to good old reliable LibreOffice, which supports this basic functionality.
I noticed this last year and thought, OK well I'm sure they'll be getting around to fixing this soon. Now I'm seeing from this thread that people have been complaining about it since November 2015! I'm really shocked that this hasn't been resolved. It might sound like an exaggeration, but to me the functionality of Excel is greatly reduced by this small omission. If Microsoft plan on maintaining a cut down service (I was already annoyed when I saw that there's no way to add user-defined-functions), they should consider reducing the annual fee. What could be so difficult about summing two non-adjacent cells anyway?
How has it been five years since this issue was brought up and it has not been resolved yet? Seems like an incredibly easy fix
You can do a work around using the Sum function and using a "," but that doesn't help if you need to select multiple rows with more data. Anyone got a work around for that?
BRIAN SMITH commented
you have got to be kidding me. Going back to Google sheets. This is laughable.
Elicia Gaylord commented
The lack of this functionality makes it extremely tedious and frustrating to use. I would avoid using Excel online at all costs because of this fact alone if not for the fact that I'm forced to use it at work
It's as if excel is maintained by product managers who never use it. The only reasonable workaround for me is to sync it on my machine and open it using the desktop app for Excel.
Danielle Henry commented
Can't believe it has been this long and this hasn't been resolved. I'm not a super techy person but I can't imagine this is difficult to change. Seems like a basic concept. Very frustrating - really impairs my work function.
Samantha Pilgrim commented
Just experienced this huge omission for myself. Can't create any useful charts.
Tim Clarke commented
Absolutely blown away that this functionality is missing.
This makes the web version a total non-starter for anything other than basic data entry and simple calculation. You might as well remove 80% of the other options in the ribbon and menus if leaving this ability out is a conscious decision.
Seriously, this is a big functionality issue - it's 2020 and this is from 2015....
Because of that feature, people in the company forced to use Google Docs!
2012 Coyote commented
So i found a fairly easy workaround for this issue... when doing something like autosum first start autosum from the home tab at the top then click on your first cell, you should see the cell label in the autosum box "eg. D4", next press the comma key on your keyboard and then click on the next cell.. eg. D4,A6 and continue repeating until all cells are checked, placing a comma in between each cell label. Then press enter to get your autosum value.
can't believe this is an issue. been using Excel since 1994... why???
Re-posting this since now its almost 2020 without a single word from Microsoft. Very sad...
This functionality is a requirement of any spreadsheet program.
Apparently Microsoft needs people to "vote" on this more, to allocate time to it. Very surprised this made it to release without this functionality. People, because Microsoft's Dev Team is apparently underfunded, please encourage your co-workers or friends to take a minute to vote on this. Without these votes, no resources will get allocated to this.
The only reason this doesn't have thousands of up-votes is that most people see this feature doesn't exist and simply dismiss this program from ever being used in their workflow. This is what I did... its unusable. However this time I said, "you know what? No, I need to say something". I and hundreds of thousands of others will continue to not use this program until this is fixed, and the MAJORITY will not vote because it's simply a non-starter of a spreadsheet solution.
If anyone is reading this, please encourage someone else to "vote" on this so the underfunded Dev Team and Management will be forced not to ignore it.
Thanks all. Microsoft, please understand that the lack of votes on this does NOT correlate to the lack of priority. Thank you.
I thought I'm the only one who's frustrated about this. Please add this feature. It'll be year 2020 already.
Adam W commented
Why is this even an issue. Come on Microsoft, you have to know this is an important feature.
Charles R commented
Absolutely essential. Is this really that difficult to program? Or to add a different key combination?
T Sampson commented
This is essential functionality for use of charts visualization