This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to select non-adjacent cells in Excel by holding down the Control Key and selecting the cells but it does not work. Instead I get the same menu as with a left mouse-click. I have a Macbook Air M2 with Office 365 Personal. I've tried with both the Magic Mouse and Trackpad.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Use the Command key instead of the Control key.
Command+Click on a Mac is the equivalent of right+clicking to elicit a contextual menu.
Another method is to enter the cell references in the Name Box at the left end of the Formula Bar separating the cell references & ranges by a comma. E.g., to select cell a1 plus cells b3 through b9 plus cell c5 enter this exact string a1,b3:b9,c5 then press return.
The same can be done using the Edit< Find> Go To dialog.