Sep 07 2020 01:24 PM
Hi,
I am trying to paste a URL in my excel sheet, but instead of getting copied as a link, it gets copied as a text-only. I started to have this problem for around 3 or 4 days ago, earlier the URL automatically gets copied as a link but now I have to right-click that text and set up the link manually.
Please Help !!!
Here are some snapshots:
Copying the URL directly to the excel sheet.
Changing the text to link manually:
Sep 16 2020 06:40 AM
I think if you follow these steps, your problem will be solved.
In Excel
1. File > Options > Proofing (from the left pane)
2. By the Autocorrect options click the AutoCorrect Options button (from the right pane)
3. Select AutoFormat As You Type tab
4. Check the box Internet and network paths with hyperlinks
5. Click OK and close
Greetings
Hasan Emre SATILMIŞ
Sep 16 2020 11:10 PM
Thank you for your reply. I tried your way but it didn't work.
The box for 'Internet and network paths with hyperlinks' was already check marked when i opened the settings.
I tried to uncheck it and then check marked it again, but it didn't work.
Regards
Navjot Singh
Sep 16 2020 11:45 PM
Create a hyperlink to a website
1. Click the cell you want to create the link in.
2. Click on "Hyperlink". The hyperlink window appears.
3. For "Link to:" click on "File or Web Page".
4. For "Show text as:" enter the link name you want.
5. Enter the desired web address in the "Address field" or select a page under "Visited websites".
6. Click OK.
7. The cell content appears as a link.
8. You can open the link by double-clicking the link.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Sep 17 2020 12:47 AM
This link includes a few different methods for using hyperlink in excel. I hope that will be useful.
https://www.contextures.com/excelhyperlinkfunction.html
Greetings
Hasan Emre SATILMIŞ
Sep 18 2020 10:35 PM
HI everyone,
i was trying to resolve the problem and look out for your replies and then i noticed that, the URL gets automatically converted to link when i removed the letter 's' from https, so now by entering a website's URL with HTTP, it automatically gets converted to link.
For example, i used http://www.youtube.com/ (removed the 's') instead of https://www.youtube.com/ which is the default url that gets copied for youtube.
I know It is be kind of weird but i don't know if it's an issue with excel or what, but it kinda worked
Sep 19 2020 02:05 AM
Because when you remove the letter 's' you have written link manually. If you write a link manually in excel, the link will convert to hyperlink automatically.
I have the same issue with Chrome. But when I use the Edge, everything is running correctly (when I copy and paste links which are http or https).
Greetings
Hasan Emre SATILMIŞ