Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

HyperLinks in Excel. How to remove?

I pasted in a table from a webpage and I need to get rid of the links in one of the columns. Any idea how?

2 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    Clicking a cell with hyperlink will run it, so select the range of cells that have that link and press Delete.

    OR

    Right click on that cell and select "Remove Hyperlink"

    OR

    Click and hold to select the cell without running the link, then press Delete.

    Enjoy my profile, I am the VBAXLMan

  • 1 decade ago

    u right click on the table and then at the bottom there will be a chocie that say to remove hyper link just click that and it will be gone

Still have questions? Get your answers by asking now.