{"id":3991,"date":"2022-12-01T15:55:43","date_gmt":"2022-12-01T15:55:43","guid":{"rendered":"https:\/\/pt.repairmsexcel.com\/blog\/?p=3991"},"modified":"2022-12-01T15:58:45","modified_gmt":"2022-12-01T15:58:45","slug":"remover-hiperlinks-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel","title":{"rendered":"Como desativar e remover Hiperlinks no Excel?"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">No <strong>Excel<\/strong>, os hiperlinks s\u00e3o \u00fateis, mas \u00e0s vezes eles se tornam muito irritantes, pois podem causar confus\u00e3o se voc\u00ea quiser manter os dados organizados.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, por padr\u00e3o, o Excel converte todos os URLs e o endere\u00e7o de e-mail em hiperlinks clic\u00e1veis, o que \u00e9 um pouco irritante. Felizmente, existem maneiras de desativar e remover hiperlinks no Excel.<!--more--><\/p>\n<p style=\"text-align: justify;\">No tutorial do artigo, aprenda as maneiras f\u00e1ceis de remover hiperlinks em uma planilha do Excel.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Como remover todos os Hiperlinks em algumas etapas?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Aqui, descubra as maneiras f\u00e1ceis de remover hiperlinks.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Voc\u00ea pode selecionar a coluna inteira com hiperlinks clicando em qualquer c\u00e9lula com dados e pressionando <strong>Ctrl+Space<\/strong>.<\/li>\n<li>\u201c<strong>Remover hiperlinks<\/strong>\u201d pode ser escolhido no menu de contexto clicando com o bot\u00e3o direito do mouse em qualquer c\u00e9lula selecionada.<\/li>\n<li>E todos os hiperlinks s\u00e3o removidos.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3993 size-full aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/1.png\" alt=\"remover Hiperlinks no Excel\" width=\"643\" height=\"403\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/1.png 643w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/1-300x188.png 300w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Como remover Hiperlinks no Excel usando VBA?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Suponha que voc\u00ea ainda esteja utilizando uma vers\u00e3o anterior do Excel. Ou talvez voc\u00ea tenha usado o menu de contexto do bot\u00e3o direito do mouse com muita frequ\u00eancia porque sua pasta de trabalho cont\u00e9m muitos hiperlinks.<\/p>\n<p style=\"text-align: justify;\">Nesse caso, voc\u00ea pode usar o c\u00f3digo de macro-VBA para remover v\u00e1rios hiperlinks no Microsoft Excel.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Para abrir seu editor VBA, pressione <strong>Alt+F11<\/strong>.<\/li>\n<li>Clique duas vezes em <strong>ThisWorkbook<\/strong> na Project Window que agora est\u00e1 vis\u00edvel no canto esquerdo do editor VBA.<\/li>\n<li>Em seguida, copie e cole o c\u00f3digo VBA listado na janela M\u00f3dulo:<\/li>\n<li>Para executar o m\u00f3dulo de c\u00f3digo VBA, pressione <strong>F5<\/strong>.<\/li>\n<li>Isso apagar\u00e1 instantaneamente todos os hiperlinks de sua pasta de trabalho. Eles n\u00e3o s\u00e3o mais uma preocupa\u00e7\u00e3o para voc\u00ea. Mas tenha em mente que esta a\u00e7\u00e3o n\u00e3o pode ser desfeita. Ctrl+Z n\u00e3o pode ser usado para reverter a remo\u00e7\u00e3o de hiperlinks.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Esse c\u00f3digo VBA pode ser salvo como um bot\u00e3o simples de clicar e esquecer no <strong>QAT (Quick Access toolbar).<\/strong> Este \u00e9 um truque f\u00e1cil para remover todos os hiperlinks da planilha do Excel em apenas alguns cliques.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Feche a janela do editor VBA ap\u00f3s adicionar o m\u00f3dulo de c\u00f3digo VBA.<\/li>\n<li>Selecione Mais comandos clicando em <strong>Customize Quick Access Toolbar<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3994 \" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/2.png\" alt=\"remover Hiperlinks no Excel\" width=\"625\" height=\"507\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/2.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/2-300x243.png 300w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha <strong>Macros<\/strong> na lista suspensa em <strong>Escolher comandos<\/strong> na lista suspensa na caixa Op\u00e7\u00f5es do Excel.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3995 aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/3.png\" alt=\"remover Hiperlinks no Excel\" width=\"658\" height=\"538\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/3.png 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/3-300x245.png 300w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Selecione o <strong>m\u00f3dulo de c\u00f3digo VBA<\/strong> que acabamos de adicionar rolando para baixo e fazendo isso.<\/li>\n<li>Clique em <strong>OK<\/strong> ap\u00f3s selecionar <strong>Adicionar<\/strong>.<\/li>\n<li>S\u00f3 isso. A barra de ferramentas de acesso r\u00e1pido receber\u00e1 um bot\u00e3o de acesso r\u00e1pido para executar este c\u00f3digo VBA.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Estas s\u00e3o as 2 maneiras detalhadas de remover hiperlinks clic\u00e1veis \u200b\u200bno Excel.<\/p>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>Leia tamb\u00e9m: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/resolver-excel-hyperlinks-nao-trabalhando\" target=\"_blank\" rel=\"noopener\">3 maneiras de corrigir problemas de hiperlinks do Excel que n\u00e3o funcionam<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Como remover v\u00e1rios Hiperlinks do Excel?<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Apenas uma fun\u00e7\u00e3o interna no <strong>Excel 2000-2007<\/strong> permite apagar v\u00e1rios hiperlinks de uma s\u00f3 vez. Aqui est\u00e1 uma dica r\u00e1pida que ajudar\u00e1 voc\u00ea a contornar essa restri\u00e7\u00e3o. Funciona no <strong>Excel 2019, 2016 <\/strong>e<strong> 2013 <\/strong>tamb\u00e9m.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha uma c\u00e9lula em branco em algum lugar fora de sua mesa.<\/li>\n<li>Para esta c\u00e9lula, digite 1 e <strong>Ctrl + C<\/strong> copiar\u00e1 esta c\u00e9lula.<\/li>\n<li>Escolha suas colunas usando os hiperlinks: Para selecionar toda a primeira coluna, clique em qualquer c\u00e9lula que contenha dados e pressione <strong>Ctrl+Space<\/strong>.<\/li>\n<li>Se voc\u00ea deseja escolher v\u00e1rias colunas de uma s\u00f3 vez, escolha a primeira coluna primeiro e, enquanto mant\u00e9m pressionada a tecla <strong>Ctrl<\/strong>, clique em qualquer c\u00e9lula na segunda coluna e, em seguida, pressione a tecla <strong>Space<\/strong> para selecionar cada c\u00e9lula na segunda coluna sem afetar o sele\u00e7\u00e3o na primeira coluna.<\/li>\n<li>Clique com o bot\u00e3o direito do mouse em qualquer c\u00e9lula escolhida para abrir o menu de contexto e escolha \u201c<strong>Paste Special<\/strong>\u201d:<\/li>\n<li>Selecione o bot\u00e3o de r\u00e1dio \u201c<strong>Multiplicar<\/strong>\u201d na se\u00e7\u00e3o \u201cOpera\u00e7\u00e3o\u201d da caixa de di\u00e1logo \u201cColar Especial\u201d:<\/li>\n<li>Clique em \u201c<strong>OK<\/strong>\u201d. Todos os links foram desativados.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Como desativar a cria\u00e7\u00e3o autom\u00e1tica de Hiperlink do Excel?<\/strong><\/span><\/h2>\n<ul style=\"text-align: justify;\">\n<li>Selecione Op\u00e7\u00f5es do Excel no <strong>bot\u00e3o Office<\/strong> no Excel 2007.<\/li>\n<li>Navegue at\u00e9 a guia Arquivo -&gt; Op\u00e7\u00f5es no Excel <strong>2010 \u2013 2019<\/strong>.<\/li>\n<li>Selecione a guia \u201c<strong>Proofing<\/strong>\u201d na coluna esquerda da caixa de di\u00e1logo \u201cOp\u00e7\u00f5es do Excel\u201d e clique no bot\u00e3o \u201c<strong>Op\u00e7\u00f5es de AutoCorre\u00e7\u00e3o<\/strong>\u201d:<\/li>\n<\/ul>\n<p><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3996 size-full aligncenter\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/4.png\" alt=\"remover Hiperlinks no Excel\" width=\"613\" height=\"496\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/4.png 613w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/4-300x243.png 300w\" sizes=\"auto, (max-width: 613px) 100vw, 613px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Selecione a guia \u201c<strong>Formata\u00e7\u00e3o autom\u00e1tica ao digitar<\/strong>\u201d na caixa de di\u00e1logo \u201c<strong>Op\u00e7\u00f5es de autocorre\u00e7\u00e3o<\/strong>\u201d e desmarque a caixa de sele\u00e7\u00e3o \u201c<strong>Rotas de Internet e rede com hiperlinks<\/strong>\u201d.<\/li>\n<li>Para encerrar os dois di\u00e1logos e retornar \u00e0 planilha do Excel, clique em <strong>OK<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3997 size-full\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/5.png\" alt=\"remover Hiperlinks no Excel\" width=\"422\" height=\"410\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/5.png 422w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/5-300x291.png 300w\" sizes=\"auto, (max-width: 422px) 100vw, 422px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, voc\u00ea pode inserir qualquer URL ou endere\u00e7o de e-mail em qualquer c\u00e9lula e o Excel manter\u00e1 o formato de texto simples:-)<\/li>\n<li>Use <strong>Ctrl+K <\/strong>para abrir a caixa de di\u00e1logo \u201c<strong>Inserir hiperlink<\/strong>\u201d sempre que precisar criar um hiperlink.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><strong>Conclus\u00e3o:<\/strong><\/h2>\n<p style=\"text-align: justify;\">Portanto, trata-se de como remover hiperlinks no Excel. Este tutorial tamb\u00e9m discute como desabilitar hiperlinks no Microsoft Excel com apenas alguns cliques. Siga as instru\u00e7\u00f5es passo a passo cuidadosamente para remover e desativar os hiperlinks no Excel.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, se o seu arquivo do Excel estiver corrompido, voc\u00ea pode usar este recomendado profissionalmente <a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener\"><strong>Excel Arquivo Reparar Software<\/strong><\/a> para corrigir arquivos XLS e XLSX corrompidos. Esta \u00e9 a melhor ferramenta que ajuda voc\u00ea a reparar e recuperar dados <strong>corrompidos, danificados e inacess\u00edveis em arquivos XLS e XLSX<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Agora voc\u00ea tamb\u00e9m pode nos seguir em nossas p\u00e1ginas do <a href=\"https:\/\/www.facebook.com\/MS-Excel-Repair-Tool-1569953153234271\" target=\"_blank\" rel=\"noopener\"><strong>Facebook<\/strong><\/a>, <a href=\"https:\/\/twitter.com\/repairmsexcel\" target=\"_blank\" rel=\"noopener\"><strong>Twitter<\/strong><\/a> e compartilhar suas d\u00favidas relacionadas a erros do Excel, corrup\u00e7\u00e3o, recupera\u00e7\u00e3o de dados e outros; nossos especialistas entrar\u00e3o em contato com voc\u00ea.<\/p>\n<p style=\"text-align: justify;\">Boa sorte..!<\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>No Excel, os hiperlinks s\u00e3o \u00fateis, mas \u00e0s vezes eles se tornam muito irritantes, pois podem causar confus\u00e3o se voc\u00ea &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Como desativar e remover Hiperlinks no Excel?\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#more-3991\" aria-label=\"Read more about Como desativar e remover Hiperlinks no Excel?\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":3992,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[1341,1340,1342],"class_list":["post-3991","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-remover-hiperlinks-no-excel","tag-desativar-hiperlink-automatico-no-excel","tag-remover-hiperlinks-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Como desativar e remover Hiperlinks no Excel?<\/title>\n<meta name=\"description\" content=\"Quer saber como remover ou desativar links clic\u00e1veis no Excel e siga as etapas fornecidas para remover hiperlinks no Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como desativar e remover Hiperlinks no Excel?\" \/>\n<meta property=\"og:description\" content=\"Quer saber como remover ou desativar links clic\u00e1veis no Excel e siga as etapas fornecidas para remover hiperlinks no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-01T15:55:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-01T15:58:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/PT-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Como desativar e remover Hiperlinks no Excel?\",\"datePublished\":\"2022-12-01T15:55:43+00:00\",\"dateModified\":\"2022-12-01T15:58:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel\"},\"wordCount\":958,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/PT-1.png\",\"keywords\":[\"Como remover hiperlinks no Excel\",\"DESATIVAR HIPERLINK AUTOM\u00c1TICO NO EXCEL\",\"Remover hiperlinks no Excel\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel\",\"name\":\"Como desativar e remover Hiperlinks no Excel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/PT-1.png\",\"datePublished\":\"2022-12-01T15:55:43+00:00\",\"dateModified\":\"2022-12-01T15:58:45+00:00\",\"description\":\"Quer saber como remover ou desativar links clic\u00e1veis no Excel e siga as etapas fornecidas para remover hiperlinks no Excel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/PT-1.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/PT-1.png\",\"width\":550,\"height\":300,\"caption\":\"remover Hiperlinks no Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/remover-hiperlinks-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como desativar e remover Hiperlinks no Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como desativar e remover Hiperlinks no Excel?","description":"Quer saber como remover ou desativar links clic\u00e1veis no Excel e siga as etapas fornecidas para remover hiperlinks no Excel.","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:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel","og_locale":"en_US","og_type":"article","og_title":"Como desativar e remover Hiperlinks no Excel?","og_description":"Quer saber como remover ou desativar links clic\u00e1veis no Excel e siga as etapas fornecidas para remover hiperlinks no Excel.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2022-12-01T15:55:43+00:00","article_modified_time":"2022-12-01T15:58:45+00:00","og_image":[{"width":550,"height":300,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/PT-1.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Como desativar e remover Hiperlinks no Excel?","datePublished":"2022-12-01T15:55:43+00:00","dateModified":"2022-12-01T15:58:45+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel"},"wordCount":958,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/PT-1.png","keywords":["Como remover hiperlinks no Excel","DESATIVAR HIPERLINK AUTOM\u00c1TICO NO EXCEL","Remover hiperlinks no Excel"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel","name":"Como desativar e remover Hiperlinks no Excel?","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/PT-1.png","datePublished":"2022-12-01T15:55:43+00:00","dateModified":"2022-12-01T15:58:45+00:00","description":"Quer saber como remover ou desativar links clic\u00e1veis no Excel e siga as etapas fornecidas para remover hiperlinks no Excel.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/PT-1.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/12\/PT-1.png","width":550,"height":300,"caption":"remover Hiperlinks no Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/remover-hiperlinks-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Como desativar e remover Hiperlinks no Excel?"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3991","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=3991"}],"version-history":[{"count":2,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3991\/revisions"}],"predecessor-version":[{"id":3999,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/3991\/revisions\/3999"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/3992"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=3991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=3991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=3991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}