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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-06-04T17:18:02+00:00

    I hope they find a solution soon, it's frustrating!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-05-28T17:52:47+00:00

    I am havingthe same issue. Saw another question posted See "HOW do I turn off Ctrl+Click option for opening hyperlinks I added to cells in Excel on OneDrive?". According to the person there is a new built in feature. This is extremely infuriating as i work with links on OneDrive constantly.

    "Sean Cai MSFT

    Microsoft Agent | Moderator

    Replied on May 17, 2024

    ,

    Thank you for reaching out to the Microsoft community. We are delighted to offer our assistance.

    After carefully reviewing your description, we feel sorry to say that this is a built-in feature and currently, there isn't an option to turn it off. We apologize for any inconvenience caused by this limitation.

    Thank you for your understanding and cooperation! Have a great day.

    Sincerely,

    Sean | Microsoft Community Moderator"

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2024-04-14T13:53:26+00:00

    Hi, thank you for reaching out. My name is Deeksha and I'm a Microsoft user like yourself and I will try to help you as best as I can today.

    To make hyperlinks in Excel work automatically without needing to press Ctrl and click, you can adjust the settings in Excel. Here's how you can change this setting:

    Open Excel and click on File > Options. In the Excel Options dialog box, select Advanced. Scroll down to the Editing options section. Uncheck the box next to Use CTRL + Click to follow hyperlink. Click OK to save your changes and close the dialog box. After doing this, clicking on hyperlinks should follow the link directly without needing the Ctrl key.

    Try these steps and hopefully, it resolves your issue. In case you need further help or assistance, please let us know. You can also contact Microsoft Support if the problem persists.

    Best regards Deeksha

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments