{"id":379754,"date":"2021-12-11T19:00:22","date_gmt":"2021-12-11T16:00:22","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-remove-hyperlinks-in-microsoft-excel\/"},"modified":"2021-12-11T19:00:22","modified_gmt":"2021-12-11T16:00:22","slug":"how-to-remove-hyperlinks-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-remove-hyperlinks-in-microsoft-excel\/","title":{"rendered":"#How to Remove Hyperlinks in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2dd3773b097\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2dd3773b097\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-hyperlinks-in-microsoft-excel\/#How_to_Remove_a_Single_Hyperlink_in_Excel\" >How to Remove a Single Hyperlink in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-hyperlinks-in-microsoft-excel\/#How_to_Remove_Multiple_Hyperlinks_in_Excel\" >How to Remove Multiple Hyperlinks in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-hyperlinks-in-microsoft-excel\/#How_to_Stop_Excel_From_Turning_Your_Links_Into_Hyperlinks\" >How to Stop Excel From Turning Your Links Into Hyperlinks<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Remove Hyperlinks in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Want to remove those clickable links from your Microsoft Excel spreadsheets? If so, it\u2019s easy to remove those links or prevent Excel entirely from turning your typed text into web links. We\u2019ll show you how to do both.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Remove Underlined Hyperlinks in PowerPoint<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Remove_a_Single_Hyperlink_in_Excel\"><\/span>How to Remove a Single Hyperlink in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To quickly remove an individual hyperlink from your Excel spreadsheet, use an option from your right-click menu.<\/p>\n<p>To do that, first, open your spreadsheet with Excel. Find the cell that has the link you want to remove.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764476\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/1-select-hyperlink.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a hyperlink.\" width=\"629\" height=\"267\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Right-click that cell, and from the menu that opens, select \u201cRemove Hyperlink.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764477\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/2-remove-single-hyperlink.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Remove Hyperlink&quot; from the context menu.\" width=\"650\" height=\"266\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And your selected hyperlink is now removed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764478\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/3-single-hyperlink-removed.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A removed hyperlink.\" width=\"631\" height=\"282\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>That\u2019s it. You can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/howto\/16346\/how-to-remove-hyperlinks-from-microsoft-word-documents\/\">remove hyperlinks from Word documents in a similar way.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Remove Hyperlinks from Microsoft Word Documents<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Remove_Multiple_Hyperlinks_in_Excel\"><\/span>How to Remove Multiple Hyperlinks in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to remove multiple hyperlinks from your Excel spreadsheet at once, you can again use the Excel context menu option.<\/p>\n<p>To do so, first, open your spreadsheet with Excel.<\/p>\n<p>In the spreadsheet, select the links you want to remove. You can select as many links as you want.<\/p>\n<p>To remove links from your entire worksheet, press Ctrl+A (Windows) or Command+A (Mac) to select your entire worksheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764479\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/4-select-hyperlinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select multiple hyperlinks.\" width=\"634\" height=\"292\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>While your hyperlinks are selected, <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/747755\/how-to-right-click\/\">right-click anywhere on your worksheet and choose \u201cRemove Hyperlinks\u201d from the menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764480\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/5-remove-multiple-hyperlinks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Remove Hyperlinks&quot; from the right-click menu.\" width=\"650\" height=\"216\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And Excel will remove all your selected hyperlinks!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764481\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/6-multiple-hyperlinks-removed.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Selected hyperlinks removed.\" width=\"636\" height=\"289\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019re all set. If you enter a lot of dates in Excel, you might like to know how to convert text to date values.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Stop_Excel_From_Turning_Your_Links_Into_Hyperlinks\"><\/span>How to Stop Excel From Turning Your Links Into Hyperlinks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By default, when you type a web address in your spreadsheet, Excel automatically converts it to a hyperlink. To prevent this, you can toggle off an option in Excel settings.<\/p>\n<p>To do so, in Excel\u2019s top-left corner, click \u201cFile.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764482\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/7-excel-file-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;File&quot; in Excel's top-left corner.\" width=\"550\" height=\"237\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From the left sidebar, select More &gt; Options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764483\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/8-excel-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select More &gt; Options from Excel's left sidebar.\" width=\"650\" height=\"250\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>An \u201cExcel Options\u201d window will open. In this window, from the left sidebar, select \u201cProofing.\u201d Then, on the right, click \u201cAutoCorrect Options.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764484\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/9-autocorrect-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;AutoCorrect Options&quot; on the &quot;Excel Options&quot; window.\" width=\"650\" height=\"267\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You will see an \u201cAutoCorrect\u201d window. At the top of this window, click \u201cAutoFormat As You Type.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764485\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/10-autoformat-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;AutoFormat As You Type&quot; on the &quot;AutoCorrect&quot; window.\" width=\"418\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the \u201cAutoFormat As You Type\u201d tab, in the \u201cReplace As You Type\u201d section, turn off the \u201cInternet and Network Paths With Hyperlinks\u201d option. Then click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764486\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/11-disable-hyperlinks-excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Disable &quot;Internet and Network Paths With Hyperlinks&quot; and click &quot;OK.&quot;\" width=\"418\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Close the \u201cExcel Options\u201d window by clicking \u201cOK\u201d at the bottom.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-764488\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/12-close-excel-options.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click &quot;OK&quot; on the &quot;Excel Options&quot; window.\" width=\"650\" height=\"328\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>From now on, Excel won\u2019t automatically convert your text into hyperlinks. Very useful in many cases!<\/p>\n<hr\/>\n<p>Similarly, you can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/363265\/update-how-to-disable-automatic-hyperlinks-in-microsoft-word\/\">disable automatic hyperlinks in Microsoft Word, too.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Disable Automatic Hyperlinks in Microsoft Word<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/764471\/how-to-remove-hyperlinks-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Remove Hyperlinks in Microsoft Excel&#8221; Want to remove those clickable links from your Microsoft Excel spreadsheets? If so, it\u2019s easy to remove those links or prevent Excel entirely from turning your typed text into web links. We\u2019ll show you how to do both. RELATED: How to Remove Underlined Hyperlinks in PowerPoint How to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":379755,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-379754","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/379754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=379754"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/379754\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/379755"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=379754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=379754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=379754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}