I cannot remove the 'ctrl and click option for hyperlink - I JUST want to click on the cell and automatically open the hyperlink.

Anonymous
2024-04-14T12:52:10+00:00

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!!

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments
Answer accepted by question author
Anonymous
2024-06-04T14:21:42+00:00

I found that hovering over the link pops up the link. Click it and the tab opens as the active tab.

Was this answer helpful?

5 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2024-06-04T14:14:21+00:00

I Found a work around, select Cell / right click mouse / link options /open link

Was this answer helpful?

3 people found this answer helpful.
0 comments

61 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-05-30T13:32:23+00:00

    Microsoft apparently made it so this is the way links in the web version of excel work now and there is no fix -- it's a built-in 'feature' ---according to the answer from a Microsoft moderator on the thread I'm linking below:

    HOW do I turn off Ctrl+Click option for opening hyperlinks I added to cells in Excel on OneDrive?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-05-30T05:40:36+00:00

    Hi Deeksha

    This is only applicable on a word File. Could you suggest for excel.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-05-29T19:00:34+00:00

    I gave a Microsoft help desk person remote access to my laptop and OneDrive today and re-created the problem to help them understand.

    Nice person and she tried a few things but I don’t think she was able to offer much in the way of a solution, she said she would ask her technical team to look at it and wanted to close the help request as resolved, I insisted she leave it open and unresolved.

    Later I received an advice email suggesting I look at an irrelevant post from 2019 and the following:

    If you prefer here's some-help resources:

    • Microsoft Support: provides self-help instructions for common customer questions.
    • Microsoft Community: provides answers to questions others have asked (yours might be the same), or you can ask a new one for free. If you're new to Community, click Get more info for information on how to search for a solution or ask a question.

    So, we’re no closer to getting this resolved.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments