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 have a document I share using Excel online via onedrive. I update it in on the desktop app and people access it via a link, and view it on the Web version.
Up until yesterday, a viewer would be able to click a cells with a hyperlink to another sheet in the workbook, and it would automatically take them there. Today, every single cell with a hyperlink requests the viewer to 'ctrl and click' to follow the hyperlink.
I have gone though every single option on my desktop Excel app to try and turn off this 'ctrl and click' functuon but I genuinely cannot find anything relevant or that has worked. I have the latest version of Excel for Mac and I haven't changed any settings.
Please, how do I make hyperlinks work automatically again? Thank you!!
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.
I found that hovering over the link pops up the link. Click it and the tab opens as the active tab.
I Found a work around, select Cell / right click mouse / link options /open link
This broke one of my most crucial spreadsheets that used the links to connect jobs to other jobs. it broke my automated codes and causes great frustration and headache here. There's not a person on the PLANET who thinks CTRL+Click is the best way to click on a link. it's just counterintuitive to how the internet world exists!!
THIS NEEDS TO BE REVERTED TO HOW IT ONCE WAS
Signed, A Very Angry Guy
I 1000% percent agree. [Ctrl] + Click should be an option and not enabled as default.
I also look forward to Microsoft undoing this "update" and allowing [ctrl] + click as an option.
The number of people who rely on my spreadsheets with hyperlinks have ALL reached out to me asking me how to "disable" the [ctrl] + click option. Microsoft: Fix this. Thanks!
Sean isn't on this thread. To find that thread so you can reply directly back to Sean, Google "HOW do I turn off Ctrl+Click option for opening hyperlinks I added to cells in Excel on OneDrive?"