{"id":3781,"date":"2018-07-02T02:40:37","date_gmt":"2018-07-02T02:40:37","guid":{"rendered":"https:\/\/www.isumsoft.com\/it\/?p=3781"},"modified":"2019-11-28T08:19:14","modified_gmt":"2019-11-28T08:19:14","slug":"remove-all-hyperlinks-in-excel-2016-document","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/","title":{"rendered":"How to Remove All Hyperlinks in Excel 2016 Document"},"content":{"rendered":"<p>Sometimes, in meetings or at work, many people add links to the Excel worksheet for convenience, allowing a click of the mouse to access the page they want to access. But if you don&#8217;t want these hyperlinks in the excel table for some reason, you can delete them all at once.<\/p>\n<p>There are many ways to cancel hyperlinks in an excel table. It is very simple to delete only one hyperlink or more, just place the mouse over the hyperlink, and then right-click the mouse button and select &#8220;<strong>Remove Hyperlinks<\/strong>&#8220;. But if there are a lot of hyperlinks in the Excel worksheet, how do we cancel it? If you cancel each one manually, it would be a waste of time. What is the best way to cancel these hyperlinks at once? Here&#8217;s how to<a href=\"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/\">cancel all hyperlinks in the Excel worksheet<\/a>.<\/p>\n<ul>\n<li><a href=\"#method1\">Method 1: Remove all hyperlinks in Excel 2016 document by choosing all cells<\/a><\/li>\n<li><a href=\"#method2\">Method 2: Remove all hyperlinks from Excel 2016 document through Macro<\/a><\/li>\n<li><a href=\"#method3\">Method 3: Remove hyperlinks in Excel 2016 document by using Paste Special<\/a><\/li>\n<\/ul>\n<h2><a id=\"method1\" name=\"method1\"><\/a>Method 1: Remove all hyperlinks in Excel 2016 document by choosing all cells<\/h2>\n<p>Open the Excel 2016 document you would like to remove hyperlinks inside. Select all the cells from which you want to remove hyperlinks by pressing <strong>Ctrl + A<\/strong> on your keyboard. Then right-click the mouse button to choose <strong>Remove Hyperlinks<\/strong>. Then all existing hyperlinks in the Excel 2016 document can be canceled immediately.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"545\" class=\"alignnone size-full wp-image-3791\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-remove-hyperlinks.png\" alt=\"choose remove hyperlinks\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-remove-hyperlinks.png 555w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-remove-hyperlinks-300x295.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-remove-hyperlinks-80x79.png 80w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/p>\n<h2><a id=\"method2\" name=\"method2\"><\/a>Method 2: Remove all hyperlinks from Excel 2016 document through Macro<\/h2>\n<p>Step 1: Open the Excel 2016 document with hyperlinks. Click <strong>View<\/strong> &gt; <strong>Macros<\/strong> &gt; <strong>Record Macro&#8230;<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"458\" class=\"alignnone size-full wp-image-3804\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/open-record-macro.png\" alt=\"open record macro\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/open-record-macro.png 555w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/open-record-macro-300x248.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/open-record-macro-80x66.png 80w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/p>\n<p>Step 2: Enter the name of the macro (<strong>delete<\/strong>), and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"458\" class=\"alignnone size-full wp-image-3798\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/input-delete.png\" alt=\"input delete\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/input-delete.png 555w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/input-delete-300x248.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/input-delete-80x66.png 80w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/p>\n<p>Step 3: Click <strong>Macros<\/strong> &gt; <strong>View Macros<\/strong> &gt; choose <strong>delete<\/strong> &gt; <strong>Edit<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"458\" class=\"alignnone size-full wp-image-3790\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-delete-and-edit.png\" alt=\"choose edit button\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-delete-and-edit.png 555w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-delete-and-edit-300x248.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-delete-and-edit-80x66.png 80w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/p>\n<p>Step 4: When the macro editor pops up, enter the corresponding codes are as follow:<\/p>\n<p><strong><em>Sub delete()<\/em><\/strong><\/p>\n<p><strong><em>Cells.Hyperlinks.Delete<\/em><\/strong><\/p>\n<p><strong><em>End Sub<\/em><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"439\" height=\"560\" class=\"alignnone size-full wp-image-3801\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/enter-the-corresponding-codes.png\" alt=\"enter the corresponding codes\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/enter-the-corresponding-codes.png 439w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/enter-the-corresponding-codes-235x300.png 235w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/enter-the-corresponding-codes-80x102.png 80w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/p>\n<p>Note: The first and third lines are built-in invariants. Change the middle content to &#8220;<strong>Cells.Hyperlinks.Delete<\/strong>&#8221; above, and then close the editor.<\/p>\n<p>Step 5: Click <strong>Macros<\/strong> &gt; <strong>View Macros<\/strong> &gt; <strong>Run<\/strong>. And then you&#8217;ll see that the cell with the hyperlink changes from blue to black.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"458\" class=\"alignnone size-full wp-image-3793\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/click-macros-view-macros-run.png\" alt=\"click run button\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/click-macros-view-macros-run.png 555w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/click-macros-view-macros-run-300x248.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/click-macros-view-macros-run-80x66.png 80w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/p>\n<h2><a id=\"method3\" name=\"method3\"><\/a>Method 3: Remove hyperlinks in Excel 2016 document by using Paste Special<\/h2>\n<p>Step 1: Select all cells that need to be unlinked, and right click the mouse button &gt; choose <strong>Copy<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"457\" class=\"alignnone size-full wp-image-3789\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-copy.png\" alt=\"copy all cells with hyperlink\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-copy.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-copy-300x241.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/choose-copy-80x64.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>Step 2: Select any blank cell, right-click the mouse button, and select &#8220;<strong>Paste Special&#8230;<\/strong>&#8220;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"532\" class=\"alignnone size-full wp-image-3796\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/select-paste-special.png\" alt=\"select paste special\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/select-paste-special.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/select-paste-special-300x280.png 300w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/select-paste-special-80x75.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>Step 3: In the pop-up dialog box, select &#8220;<strong>values<\/strong>&#8221; and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"1146\" class=\"alignnone size-full wp-image-3805\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/choose-value.png\" alt=\"choose value\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/choose-value.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/choose-value-149x300.png 149w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/choose-value-509x1024.png 509w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/choose-value-80x161.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n<p>Step 4: Delete the original cells with the hyperlink. And then the hyperlinks appear from the Excel worksheet at once.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"570\" height=\"617\" class=\"alignnone size-full wp-image-3794\" src=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/delete-the-original-cells.png\" alt=\"delete the original cells\" srcset=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/delete-the-original-cells.png 570w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/delete-the-original-cells-277x300.png 277w, https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/06\/delete-the-original-cells-80x87.png 80w\" sizes=\"auto, (max-width: 570px) 100vw, 570px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sometimes, in meetings or at work, many people add links to the Excel worksheet for convenience, allowing a click of the mouse to access the page they want to access. But if you don&#8217;t want these hyperlinks in&#8230; <\/p>\n","protected":false},"author":2,"featured_media":3814,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[164,162,163],"class_list":["post-3781","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer-tips","tag-cancel-these-hyperlinks","tag-choose-all-cells","tag-use-paste-special-and-macro"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Remove All Hyperlinks in Excel 2016 Document<\/title>\n<meta name=\"description\" content=\"If you don&#039;t want these hyperlinks to appear in the excel table for some reason, you can remove them all at once. This post introduces 3 useful ways to you.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Remove All Hyperlinks in Excel 2016 Document\" \/>\n<meta property=\"og:description\" content=\"If you don&#039;t want these hyperlinks to appear in the excel table for some reason, you can remove them all at once. This post introduces 3 useful ways to you.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/\" \/>\n<meta property=\"og:site_name\" content=\"iSumsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isumsofthome\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T02:40:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-28T08:19:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/remove-all-hyperlinks-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"525\" \/>\n\t<meta property=\"og:image:height\" content=\"318\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:site\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to Remove All Hyperlinks in Excel 2016 Document\",\"datePublished\":\"2018-07-02T02:40:37+00:00\",\"dateModified\":\"2019-11-28T08:19:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/\"},\"wordCount\":425,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/remove-all-hyperlinks-1.png\",\"keywords\":[\"cancel these hyperlinks\",\"choose all cells\",\"use\u00a0paste\u00a0special and macro\"],\"articleSection\":[\"Computer Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/\",\"name\":\"How to Remove All Hyperlinks in Excel 2016 Document\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/remove-all-hyperlinks-1.png\",\"datePublished\":\"2018-07-02T02:40:37+00:00\",\"dateModified\":\"2019-11-28T08:19:14+00:00\",\"description\":\"If you don't want these hyperlinks to appear in the excel table for some reason, you can remove them all at once. This post introduces 3 useful ways to you.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/remove-all-hyperlinks-1.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/remove-all-hyperlinks-1.png\",\"width\":525,\"height\":318,\"caption\":\"remove all hyperlinks\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/remove-all-hyperlinks-in-excel-2016-document\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Remove All Hyperlinks in Excel 2016 Document\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"name\":\"iSumsoft\",\"description\":\"Tell You More about IT World\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\",\"name\":\"iSumsoft Studio\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"width\":16,\"height\":16,\"caption\":\"iSumsoft Studio\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/isumsofthome\\\/\",\"https:\\\/\\\/x.com\\\/iSumsoft\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL9RaYqRcQ0f0buIzXiaNDw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\",\"name\":\"Darren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"caption\":\"Darren\"},\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/author\\\/darren-king\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Remove All Hyperlinks in Excel 2016 Document","description":"If you don't want these hyperlinks to appear in the excel table for some reason, you can remove them all at once. This post introduces 3 useful ways to you.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/","og_locale":"en_US","og_type":"article","og_title":"How to Remove All Hyperlinks in Excel 2016 Document","og_description":"If you don't want these hyperlinks to appear in the excel table for some reason, you can remove them all at once. This post introduces 3 useful ways to you.","og_url":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2018-07-02T02:40:37+00:00","article_modified_time":"2019-11-28T08:19:14+00:00","og_image":[{"width":525,"height":318,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/remove-all-hyperlinks-1.png","type":"image\/png"}],"author":"Darren","twitter_card":"summary_large_image","twitter_creator":"@iSumsoft","twitter_site":"@iSumsoft","twitter_misc":{"Written by":"Darren","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to Remove All Hyperlinks in Excel 2016 Document","datePublished":"2018-07-02T02:40:37+00:00","dateModified":"2019-11-28T08:19:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/"},"wordCount":425,"commentCount":0,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/remove-all-hyperlinks-1.png","keywords":["cancel these hyperlinks","choose all cells","use\u00a0paste\u00a0special and macro"],"articleSection":["Computer Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/","url":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/","name":"How to Remove All Hyperlinks in Excel 2016 Document","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/remove-all-hyperlinks-1.png","datePublished":"2018-07-02T02:40:37+00:00","dateModified":"2019-11-28T08:19:14+00:00","description":"If you don't want these hyperlinks to appear in the excel table for some reason, you can remove them all at once. This post introduces 3 useful ways to you.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/remove-all-hyperlinks-1.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2018\/07\/remove-all-hyperlinks-1.png","width":525,"height":318,"caption":"remove all hyperlinks"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/remove-all-hyperlinks-in-excel-2016-document\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to Remove All Hyperlinks in Excel 2016 Document"}]},{"@type":"WebSite","@id":"https:\/\/www.isumsoft.com\/it\/#website","url":"https:\/\/www.isumsoft.com\/it\/","name":"iSumsoft","description":"Tell You More about IT World","publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isumsoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.isumsoft.com\/it\/#organization","name":"iSumsoft Studio","url":"https:\/\/www.isumsoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","width":16,"height":16,"caption":"iSumsoft Studio"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/isumsofthome\/","https:\/\/x.com\/iSumsoft","https:\/\/www.youtube.com\/channel\/UCL9RaYqRcQ0f0buIzXiaNDw"]},{"@type":"Person","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798","name":"Darren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","caption":"Darren"},"url":"https:\/\/www.isumsoft.com\/it\/author\/darren-king\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/3781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/comments?post=3781"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/3781\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/3814"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=3781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=3781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=3781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}