Apr 09 2022 03:14 AM
I'd like to get a hypernlink when I paste a URL in excel. I made sure Options > proofing > autocorrect options > Replace as you type: Internet and network paths with hyperlinks is enabled.
How can I fix this?
Any help much appreciated
The app is: Excel - Microsft 365.
Windows 10 20H2
Apr 09 2022 03:35 AM
SolutionTry the following:
Select the cell where you want to paste the URL.
Press F2 to edit the cell, or click in the Formula bar.
Press Ctrl+V to paste.
Press Tab or Enter.
Apr 09 2022 05:35 AM - edited Apr 09 2022 05:37 AM
wow, that works. Thanks! Is there a way that Excel hyperlinks automatically without resorting to this? I think Excel was doing this before?...
Apr 09 2022 06:15 AM
If you search your favorite search engine, you'll find the method that I suggested all over the place, so apparently it has always been this way.
Apr 09 2022 03:35 AM
SolutionTry the following:
Select the cell where you want to paste the URL.
Press F2 to edit the cell, or click in the Formula bar.
Press Ctrl+V to paste.
Press Tab or Enter.