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.
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
mike r commented
MS you need to address this function. Selecting non adjacent cells is as basic as a1+b1. Come on, address this please!
Jad Zouein commented
They should add this functionality on android and ios because they are becoming more and more powerful and convenient .
When is this feature ping to be added??? I need to add some cells and now my company has change to online 365 office I am unable to use
Unbelievable. I'm used to Google Sheets, and 30 seconds into trying Excel Online I find it's been lacking a core feature for years.
Please add the ability to select multiple, non adjacent, cells using ctrl+click. As of now shift+click is the only way to select multiple cells but they have to be adjacent to each other. This causes selection of undesired cells.