Forum Discussion

Copper Contributor

Apr 04, 2019

Content became link when I copy in excel

I have been using ms excel for a long time & currently using ms excel 2016 but now I'm facing an issue. Actually, I use chrome & when I copy any content or link and then I paste in excel it becam...

excel

Twifoo

Silver Contributor

Apr 04, 2019

After copying, paste as text like this:
Alt,H,V,S then select Text and click OK.

david40lee

Copper Contributor

Apr 04, 2019

Thanks for your reply but Twifoo this is just working only for one time. It means I will have always Alt,H,V,S for normal text.

I want permanent solution as before, Every text used to copy & paste in normal way (not hyperlink).

Twifoo
Silver Contributor
Apr 04, 2019
Select all cells from which you want to remove hyperlinks (Ctrl+A), then click Hyperlink, Remove Link.
- david40lee
  Copper Contributor
  Apr 04, 2019
  Dear, this is for removing hyperlinks but I'm not looking to remove hyperlinks & I already know how to remove hyperlinks.
  
  I'm looking to know. How a copied text from a Browser, Should be a simple test while pasting in excel sheet.
  - JMB17
    Bronze Contributor
    Feb 15, 2022
    You could try right click and select text under paste options. Or, Alt+HVT if you prefer the keyboard.