Need Help in EXCEL

%3CLINGO-SUB%20id%3D%22lingo-sub-1642407%22%20slang%3D%22en-US%22%3ENeed%20Help%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1642407%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20paste%20a%20URL%20in%20my%20excel%20sheet%2C%20but%20instead%20of%20getting%20copied%20as%20a%20link%2C%20it%20gets%20copied%20as%20a%20text-only.%20I%20started%20to%20have%20this%20problem%20for%20around%203%20or%204%20days%20ago%2C%20earlier%20the%20URL%20automatically%20gets%20copied%20as%20a%20link%20but%20now%20I%20have%20to%20right-click%20that%20text%20and%20set%20up%20the%20link%20manually.%3C%2FP%3E%3CP%3EPlease%20Help%20!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20some%20snapshots%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECopying%20the%20URL%20directly%20to%20the%20excel%20sheet.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Navjot_Singh1110_0-1599510114001.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216915i6F07E4B40FDDF9FB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Navjot_Singh1110_0-1599510114001.png%22%20alt%3D%22Navjot_Singh1110_0-1599510114001.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChanging%20the%20text%20to%20link%20manually%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Navjot_Singh1110_1-1599510234117.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216916iA5F6ECEBA71418B7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Navjot_Singh1110_1-1599510234117.png%22%20alt%3D%22Navjot_Singh1110_1-1599510234117.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1673337%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1673337%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F784893%22%20target%3D%22_blank%22%3E%40Navjot_Singh1110%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20if%20you%20follow%20these%20steps%2C%20your%20problem%20will%20be%20solved.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20File%20%26gt%3B%20Options%20%26gt%3B%20Proofing%20(from%20the%20left%20pane)%3C%2FP%3E%3CP%3E2.%20By%20the%20Autocorrect%20options%20click%20the%20AutoCorrect%20Options%20button%20(from%20the%20right%20pane)%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20Select%20AutoFormat%20As%20You%20Type%20tab%3C%2FP%3E%3CP%3E4.%20Check%20the%20box%20Internet%20and%20network%20paths%20with%20hyperlinks%3C%2FP%3E%3CP%3E5.%20Click%20OK%20and%20close%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreetings%26nbsp%3B%3C%2FP%3E%3CP%3EHasan%20Emre%20SATILMI%C5%9E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676771%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676771%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778023%22%20target%3D%22_blank%22%3E%40hasanemresatilmis%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply.%20I%20tried%20your%20way%20but%20it%20didn't%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%26nbsp%3Bbox%20for%20'Internet%20and%20network%20paths%20with%20hyperlinks'%20was%20already%20check%20marked%20when%20i%20opened%20the%20settings.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20uncheck%20it%20and%20then%20check%20marked%20it%20again%2C%20but%20it%20didn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%26nbsp%3B%3C%2FP%3E%3CP%3ENavjot%20Singh%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676789%22%20slang%3D%22de-DE%22%3ERe%3A%20Need%20Help%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676789%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F784893%22%20target%3D%22_blank%22%3E%40Navjot_Singh1110%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSTRONG%3E%3CSPAN%20class%3D%22%22%3ECreate%20a%20hyperlink%20to%20a%20website%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%201.%20Click%20the%20cell%20you%20want%20to%20create%20the%20link%20in.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%202.%20Click%20on%20%22Hyperlink%22.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EThe%20hyperlink%20window%20appears.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%203.%20For%20%22Link%20to%3A%22%20click%20on%20%22File%20or%20Web%20Page%22.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%204.%20For%20%22Show%20text%20as%3A%22%20enter%20the%20link%20name%20you%20want.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%205.%20Enter%20the%20desired%20web%20address%20in%20the%20%22Address%20field%22%20or%20select%20a%20page%20under%20%22Visited%20websites%22.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3E%206.%20Click%20OK.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%207.%20The%20cell%20content%20appears%20as%20a%20link.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E%208.%20You%20can%20open%20the%20link%20by%20double-clicking%20the%20link.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1677001%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20in%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1677001%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F784893%22%20target%3D%22_blank%22%3E%40Navjot_Singh1110%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20link%20includes%20a%20few%20different%20methods%20for%20using%20hyperlink%20in%20excel.%20I%20hope%20that%20will%20be%20useful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fexcelhyperlinkfunction.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.contextures.com%2Fexcelhyperlinkfunction.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreetings%3CBR%20%2F%3EHasan%20Emre%20SATILMI%C5%9E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

Navjot_Singh1110_0-1599510114001.png

 

Changing the text to link manually:

Navjot_Singh1110_1-1599510234117.png

 

 

7 Replies
Highlighted

Hi @Navjot_Singh1110,

 

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Ş

 

 

Hi @hasanemresatilmis,

 

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

Highlighted

@Navjot_Singh1110 

 

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.

 

 

 

 

Highlighted

 

Hi @Navjot_Singh1110,

 

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Ş

 

 

Highlighted

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

 

 

Highlighted

Hi @Navjot_Singh1110,

 

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Ş

Highlighted
You need to post this in the Excel part of this forum.