# Excel Q:  Getting Rid of Hyperlinks

**URL:** <https://boards.straightdope.com/t/excel-q-getting-rid-of-hyperlinks/151709>\
**Category:** Factual Questions\
**Created:** [January 30, 2003, 8:37pm UTC](https://boards.straightdope.com/t/excel-q-getting-rid-of-hyperlinks/151709 "2003-01-30T20:37:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Polycarp](https://avatars.discourse-cdn.com/v4/letter/p/82dd89/32.png) [@Polycarp](https://boards.straightdope.com/u/Polycarp)\
**Post date:** [January 30, 2003, 8:37pm UTC](https://boards.straightdope.com/t/excel-q-getting-rid-of-hyperlinks/151709/1 "2003-01-30T20:37:10Z")

</div>

Okay, for reasons I won’t get into I’m downloading from a free site on the Web some statistics where the header and column-1 lines are hyperlinked. And my copy of Excel, which came with the machine, has the help index disabled – it wants to read the material in from the MS Office CD, which did _not_ come with the machine.

I remember from past use of Excel that there is a means of converting hyperlinks to text, but not what it is. So can anyone kindly explain the proper keystrokes to do so?

---

<div class="post-metadata">

**Author:** ![IzzyR](https://avatars.discourse-cdn.com/v4/letter/i/2acd7d/32.png) [@IzzyR](https://boards.straightdope.com/u/IzzyR)\
**Post date:** [January 30, 2003, 8:42pm UTC](https://boards.straightdope.com/t/excel-q-getting-rid-of-hyperlinks/151709/2 "2003-01-30T20:42:49Z")

</div>

I don’t know the official way to do this. But you can select the cells, copy and paste special/values one row above. Then delete the hyperlink row.

---

<div class="post-metadata">

**Author:** ![Ice\_Wolf](https://avatars.discourse-cdn.com/v4/letter/i/dfb087/32.png) [@Ice\_Wolf](https://boards.straightdope.com/u/Ice_Wolf)\
**Post date:** [January 30, 2003, 8:45pm UTC](https://boards.straightdope.com/t/excel-q-getting-rid-of-hyperlinks/151709/3 "2003-01-30T20:45:41Z")

</div>

I just use the right-click menu, select “hyperlinks” then “remove.”

---

<div class="post-metadata">

**Author:** ![Zagadka](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zagadka/32/7272_2.png) [@Zagadka](https://boards.straightdope.com/u/Zagadka)\
**Post date:** [January 30, 2003, 8:49pm UTC](https://boards.straightdope.com/t/excel-q-getting-rid-of-hyperlinks/151709/4 "2003-01-30T20:49:14Z")

</div>

Where did you purchase your computer? Any OEM software that comes pre-installed should have a disc for re-installing.