{"id":429,"date":"2023-10-29T06:40:28","date_gmt":"2023-10-29T06:40:28","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/"},"modified":"2023-12-06T11:38:17","modified_gmt":"2023-12-06T11:38:17","slug":"remover-formatacao","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/","title":{"rendered":"Como limpar a formata\u00e7\u00e3o no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1004302226\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-701113972\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>No Excel, a formata\u00e7\u00e3o \u00e9 usada para destacar c\u00e9lulas ou intervalos de c\u00e9lulas para tornar os dados relevantes facilmente vis\u00edveis. Isso pode ser feito aplicando cor de c\u00e9lula ou fonte, bordas, alinhamento, estilo de fonte e outras formata\u00e7\u00f5es.<\/p><p> E, \u00e0s vezes, voc\u00ea precisa limpar a formata\u00e7\u00e3o de alguns intervalos de c\u00e9lulas espec\u00edficos ou de toda a planilha, e fazer isso manualmente \u00e9 uma tarefa tediosa e pode ser uma possibilidade de perder alguma formata\u00e7\u00e3o para limpar se seus dados forem grandes.<\/p><p> Mas, relaxe, o Excel possui diversas maneiras de limpar a formata\u00e7\u00e3o de forma r\u00e1pida e f\u00e1cil e algumas delas est\u00e3o descritas abaixo para voc\u00ea.<\/p><h2 class=\"wp-block-heading\"> Etapas para limpar a formata\u00e7\u00e3o usando a op\u00e7\u00e3o Limpar formatos<\/h2><ol><li> Primeiro, selecione as c\u00e9lulas ou intervalo de c\u00e9lulas das quais deseja limpar a formata\u00e7\u00e3o ou a planilha inteira, se desejar limpar a formata\u00e7\u00e3o da planilha inteira.<\/li><li> Depois disso, v\u00e1 at\u00e9 a aba \u201cHome\u201d e no grupo Edi\u00e7\u00e3o, clique no \u00edcone suspenso Limpar. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-\u00edcone de limpeza da guia inicial\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\" sizes=\"auto, \" srcset=\"\" alt=\"home-tab-clear-icon\" width=\"495\" height=\"395\"><\/li><li> Agora, selecione a op\u00e7\u00e3o Limpar formatos na lista suspensa. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-selecionar-limpar-formatos\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionnez-des-formats-clairs.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-clear-formats\" width=\"196\" height=\"259\"><\/li><li> No momento em que voc\u00ea clica em Limpar formatos, todos os tipos de formata\u00e7\u00e3o aplicada, incluindo cores de c\u00e9lulas, cores de fontes, alinhamento de bordas, formata\u00e7\u00e3o condicional, etc., ser\u00e3o limpos. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 formatos exclu\u00eddos\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-formatage-efface.png\" sizes=\"auto, \" srcset=\"\" alt=\"formatting-cleared\" width=\"302\" height=\"294\"><\/li><\/ol><div class=\"wp-block-group more-box is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><ul id=\"ub_styled_list-fc5e0c8e-1a81-4ae0-81ad-53d21f6fae54\" class=\"ub_styled_list\"><li class=\"ub_styled_list_item\"> Se voc\u00ea tiver apenas algumas palavras ou caracteres coloridos nas c\u00e9lulas, o Excel n\u00e3o poder\u00e1 remover essa formata\u00e7\u00e3o de cores usando nenhuma das etapas descritas acima. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77424\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-quelques-caracteres-colores-en-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"poucos caracteres coloridos em valor\" width=\"177\" height=\"188\"><\/figure><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Limpar formata\u00e7\u00e3o usando o Format Painter<\/h2><ol><li> Primeiro, navegue at\u00e9 qualquer c\u00e9lula n\u00e3o formatada.<\/li><li> Depois disso, v\u00e1 at\u00e9 a aba \u201cHome\u201d e no grupo \u00c1rea de Transfer\u00eancia, clique em Format Painter.<\/li><li> Agora selecione a c\u00e9lula ou intervalo de c\u00e9lulas do qual deseja limpar a formata\u00e7\u00e3o. <br><img loading=\"lazy\" decoding=\"async\" title=\"formato de pintor-4-usos\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-format-peintre.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-format-painter\" width=\"430\" height=\"425\"><\/li><li> Neste ponto, toda a formata\u00e7\u00e3o aplicada ser\u00e1 apagada. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-toda a formata\u00e7\u00e3o limpa\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-tout-formatage-efface.png\" sizes=\"auto, \" srcset=\"\" alt=\"all-formatting-cleared\" width=\"287\" height=\"279\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Limpar formata\u00e7\u00e3o usando atalho de teclado<\/h2><p> O Excel tamb\u00e9m possui um atalho de teclado para limpar a formata\u00e7\u00e3o e para isso basta seguir os dois passos mencionados abaixo.<\/p><ul><li> Primeiro, selecione as c\u00e9lulas ou intervalo de c\u00e9lulas das quais deseja limpar a formata\u00e7\u00e3o ou a planilha inteira, se desejar limpar a formata\u00e7\u00e3o da planilha inteira.<\/li><li> Depois disso, basta pressionar <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>E<\/kbd> \u2192 <kbd>F<\/kbd> na ordem e a formata\u00e7\u00e3o ser\u00e1 limpa.<\/li><\/ul><h2 class=\"wp-block-heading\"> Limpar formata\u00e7\u00e3o usando c\u00f3digo VBA<\/h2><p> Voc\u00ea tamb\u00e9m pode usar o c\u00f3digo VBA para limpar a formata\u00e7\u00e3o.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\u201cA1\u201d).ClearFormats<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/nocoes-basicas-de-excel\/\">No\u00e7\u00f5es b\u00e1sicas do Microsoft Excel (componentes, pe\u00e7as e notas de conhecimento)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formato-de-numero-contabil\/\">Aplicar formato de n\u00famero cont\u00e1bil no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicione-um-numero-de-pagina\/\">Adicione um n\u00famero de p\u00e1gina no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/aplicar-estilo-de-virgula\/\">Aplicar estilo de v\u00edrgula no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/haste\/\">Aplicar tachado no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/destacar-celulas-vazias\/\">Destacar c\u00e9lulas em branco no Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-429","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como limpar a formata\u00e7\u00e3o no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Neste tutorial, aprenderemos como limpar a formata\u00e7\u00e3o no Excel. O Excel tem v\u00e1rias maneiras de limpar a formata\u00e7\u00e3o rapidamente...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como limpar a formata\u00e7\u00e3o no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, aprenderemos como limpar a formata\u00e7\u00e3o no Excel. O Excel tem v\u00e1rias maneiras de limpar a formata\u00e7\u00e3o rapidamente...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:38:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/\",\"name\":\"Como limpar a formata\u00e7\u00e3o no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\",\"datePublished\":\"2023-10-29T06:40:28+00:00\",\"dateModified\":\"2023-12-06T11:38:17+00:00\",\"description\":\"Neste tutorial, aprenderemos como limpar a formata\u00e7\u00e3o no Excel. O Excel tem v\u00e1rias maneiras de limpar a formata\u00e7\u00e3o rapidamente...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como limpar a formata\u00e7\u00e3o no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como limpar a formata\u00e7\u00e3o no Excel? (Tutorial 2023)","description":"Neste tutorial, aprenderemos como limpar a formata\u00e7\u00e3o no Excel. O Excel tem v\u00e1rias maneiras de limpar a formata\u00e7\u00e3o rapidamente...","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:\/\/exceladvisor.org\/pt\/remover-formatacao\/","og_locale":"pt_PT","og_type":"article","og_title":"Como limpar a formata\u00e7\u00e3o no Excel? (Tutorial 2023)","og_description":"Neste tutorial, aprenderemos como limpar a formata\u00e7\u00e3o no Excel. O Excel tem v\u00e1rias maneiras de limpar a formata\u00e7\u00e3o rapidamente...","og_url":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:38:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/","url":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/","name":"Como limpar a formata\u00e7\u00e3o no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png","datePublished":"2023-10-29T06:40:28+00:00","dateModified":"2023-12-06T11:38:17+00:00","description":"Neste tutorial, aprenderemos como limpar a formata\u00e7\u00e3o no Excel. O Excel tem v\u00e1rias maneiras de limpar a formata\u00e7\u00e3o rapidamente...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/remover-formatacao\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/remover-formatacao\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como limpar a formata\u00e7\u00e3o no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=429"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/429\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/429\/revisions\/1112"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}