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.
Anonymous
shared this idea
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.
330 comments
-
Atif Chaudhary
commented
Please add multiple sheets selection and editing
-
Atif Chaudhary
commented
I am using office 365 on my iPad with a keyboard attached (please note that this keyboard does not come with function keys)
I am trying to select multiple non-adjacent cells in Excel, but it is proving impossible. The normal desktop method of selecting the first cell and then holding down the control key while selecting further cells does not work here.
-
Anonymous
commented
Please add multiple sheets selection and editing
-
Donna Panter
commented
Need to be able to select non-adjacent cells on ios excel. During virtual learning the majority of my students use the iPad as their only device. I cannot teach the students MS Office applications if a large chunk of the functionality is disabled on the iPad.
-
Lesley Richards
commented
In Excel on MS Teams I cannot use the CTRL +1 to access formatting commands. I cannot use the ALT key as well to access menues. I cannot use keyboard shortcuts to insert rows and columns. Many of us who have used Excel for 25 years use keyboard commands to save our limbs from mouse induced strain and because they are so quick. Please consider these.
-
Hannia
commented
how to select non-adjacent cells ?? Please make it possibles
-
Anonymous
commented
I am able to select non-adjacent cells, but am unable to create a chart as they are grayed out.
-
Josh
commented
Is there any way to do this in the web version on a Mac? Ctrl+click has right-click functionality by default.
-
Boris
commented
Please add functionality to select non-adjacent cells in iPad OS!
-
Ovidiu
commented
Please, please, please! We need this on IpadOS as well! Please! It is very basic...
-
elise
commented
I second to the request to have it on ipad too!
-
Bethany Davis
commented
Would like this for iPad too. Thanks!
-
Adrien
commented
We definitely need this feature on iOS & iPadOS app, so frustrating not to have it yet...
-
Andreea
commented
Hi,
Still not working for me either.
Please advise!Thanks a lot in advance!
-
VolkerS
commented
Will we ever see this on iOS version of excel????? We really need this basic tool!!
Thanks
-
Anonymous
commented
For the love of God, please add this function to IOS, it is really so basic that I don't understand why it doesn´t have it!
-
Anonymous
commented
While I can select now, I still can't make charts with the data that I select in non-adjacent cells. Honestly, why would anyone pay money for this product? It is not fully functional!
-
K Martin
commented
Matt Luth - I am trying to select non-adjacent ROWS in my case, and still cannot do it by holding down control button. I need to hold control while I am on the row number. When I do, it brings up an "option" box -to cut, paste, etc. As I select the 3rd row, the first 2 become "unhighlighted. Thanks for any further help you can provide.
-
Matt Luth
commented
K Martin, I am able to click into the first cell that I want to select, then hold down CTRL and click other non-adjacent cells to select them all at once to apply a highlight for example. I couldn't do that earlier in the year.
-
K Martin
commented
Can I ask How? I still don't see where you tell us how. Please share!!!!! Frustrated Excel user :(
COMPLETED ·
ADMIN
excelonlineteam (Admin, Office.com) responded · July 26, 2020
We are excited to announce that it is now possible to select non-adjacent cells in Excel for the Web.