Hi Fergy75,
Thanks for visiting Microsoft Community.
Currently, the Excel desktop application does not have a setting to enable opening links within cells via CTRL+click. Links within cells will open directly upon clicking. If you do not wish to directly enter the link, you can extend the duration of your click until the cursor changes to a hollow crosshair; this allows you to select the cell instead.
Please refer to this official article.
Work with links in Excel - Microsoft Support
If you have any further questions, please feel free to reply to me.
Best Regards,
Jonathan Z - MSFT | Microsoft Community Support Specialist