{"id":289,"date":"2023-11-06T11:11:53","date_gmt":"2023-11-06T11:11:53","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/"},"modified":"2023-12-06T11:44:00","modified_gmt":"2023-12-06T11:44:00","slug":"formatacao-automatica","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/","title":{"rendered":"Como usar a op\u00e7\u00e3o auto format no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-2757914370\"><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-4029965234\"><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>A formata\u00e7\u00e3o \u00e9 uma tarefa tediosa. \u00c9 muito dif\u00edcil formatar seus dados toda vez que voc\u00ea os apresenta a algu\u00e9m. Mas \u00e9 a \u00fanica coisa que torna seus dados mais abrangentes e f\u00e1ceis de consumir.<\/p><p> Seria \u00f3timo se voc\u00ea tivesse uma op\u00e7\u00e3o que pudesse usar para formatar seus dados sem perder muito tempo. Ent\u00e3o, quando se trata de Excel, voc\u00ea tem uma op\u00e7\u00e3o incr\u00edvel que pode te ajudar a formatar seus dados rapidamente.<\/p><p> Seu nome \u00e9 FORMATO AUTOM\u00c1TICO. No formato autom\u00e1tico, voc\u00ea tem v\u00e1rios formatos predefinidos que pode aplicar instantaneamente aos seus dados.<\/p><p> Tudo que voc\u00ea precisa fazer \u00e9 selecionar um formato e clicar em OK para aplic\u00e1-lo. \u00c9 simples e f\u00e1cil. Em todos os formatos pr\u00e9-concebidos, voc\u00ea tem todos os componentes importantes de formata\u00e7\u00e3o, como:<\/p><ul><li> Formatando n\u00fameros<\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/fronteira\/\">Fronteiras<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/fonte-padrao\/\">Estilo de fonte<\/a><\/li><li> Padr\u00f5es e <a href=\"https:\/\/exceladvisor.org\/pt\/cor-da-celula\/\">cores de fundo<\/a><\/li><li> Alinhamento de texto<\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/largura-da-coluna\/\">Tamanho da coluna e da linha<\/a><\/li><\/ul><p> Neste artigo voc\u00ea conhecer\u00e1 essa op\u00e7\u00e3o incr\u00edvel que pode te ajudar a economizar muito tempo nos pr\u00f3ximos dias.<\/p><p class=\"qt-tip\"> <strong>Nota r\u00e1pida<\/strong> : Este \u00e9 um daqueles <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/pt\/conselho\/\" data-wpil=\"url\" data-wpel-link=\"internal\">truques do Excel<\/a> que podem ajudar a melhorar <a href=\"https:\/\/exceladvisor.org\/pt\/habilidades-de-excelencia\/\" data-wpel-link=\"internal\">as habilidades b\u00e1sicas do Excel<\/a> . Ent\u00e3o vamos come\u00e7ar\u2026<\/p><h2 class=\"wp-block-heading\"> Onde posso encontrar a op\u00e7\u00e3o AUTO FORMAT?<\/h2><p> Se voc\u00ea verificar a vers\u00e3o do Excel 2003, a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica estar\u00e1 no menu. Por\u00e9m, com o lan\u00e7amento de 2007 com faixa de op\u00e7\u00f5es, essa op\u00e7\u00e3o n\u00e3o est\u00e1 dispon\u00edvel em nenhuma das abas.<\/p><p> Isso n\u00e3o significa que voc\u00ea n\u00e3o possa us\u00e1-lo em vers\u00f5es anteriores. Ainda est\u00e1 l\u00e1, mas escondido. Portanto, para utiliz\u00e1-lo em vers\u00f5es do Excel como 2007, 2010, 2013 e 2016, \u00e9 necess\u00e1rio adicion\u00e1-lo \u00e0 barra de ferramentas de acesso r\u00e1pido do Excel. Esta \u00e9 uma configura\u00e7\u00e3o \u00fanica, ent\u00e3o voc\u00ea n\u00e3o precisa fazer isso repetidamente.<\/p><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Adicionar formata\u00e7\u00e3o autom\u00e1tica \u00e0 barra de ferramentas de acesso r\u00e1pido<\/h2><p> Para adicionar AutoFormata\u00e7\u00e3o \u00e0 sua <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/pt\/barra-de-acesso-rapido\/\" data-wpel-link=\"internal\">barra de ferramentas de acesso r\u00e1pido,<\/a> siga estas etapas.<\/p><ul><li> Primeiro, v\u00e1 para a barra de ferramentas de acesso r\u00e1pido e clique na pequena seta para baixo no final da barra de ferramentas. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"clique na caixa suspensa para ativar a formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><ul><li> E, ao clicar nele, voc\u00ea ver\u00e1 um menu suspenso. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-plus-de-commandes-pour-activer-le-format-automatique-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"clique em mais comandos para ativar a formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><ul><li> Neste menu, clique em \u201cMais Pedidos\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-plus-de-commandes-pour-activer-le-format-automatique-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"clique em mais comandos para ativar a formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><ul><li> Depois de clicar nele, ser\u00e1 aberto \u201cPersonalizar barra de ferramentas de acesso r\u00e1pido\u201d nas op\u00e7\u00f5es do Excel.<\/li><li> A partir da\u00ed, clique no menu suspenso \u201cEscolher comandos de\u201d e selecione \u201cComandos que n\u00e3o est\u00e3o na faixa de op\u00e7\u00f5es\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-les-commandes-qui-ne-se-trouvent-pas-dans-le-ruban-pour-ajouter-le-format-automatique-dans-la-barre-doutils-dacces-rapide-dExcel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"selecione comandos que n\u00e3o est\u00e3o na faixa de op\u00e7\u00f5es para adicionar formata\u00e7\u00e3o autom\u00e1tica \u00e0 barra de ferramentas de acesso r\u00e1pido do Excel\"><\/figure><\/div><ul><li> Depois disso, v\u00e1 para a lista de comandos logo abaixo desta lista suspensa.<\/li><li> E selecione a op\u00e7\u00e3o \u201cFormata\u00e7\u00e3o autom\u00e1tica\u201d e adicione-a \u00e0 barra de ferramentas de acesso r\u00e1pido. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-a-partir-de-la-commande-de-format-automatique-dans-Excel-pour-ajouter-a-la-barre-doutils-dacces-rapide-min-1.png\" sizes=\"\" srcset=\"\" alt=\"selecione o comando de formata\u00e7\u00e3o autom\u00e1tica no Excel para adicion\u00e1-lo \u00e0 barra de ferramentas de acesso r\u00e1pido\"><\/figure><\/div><ul><li> Clique OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bouton-de-formatage-automatique-dans-la-barre-doutils-dacces-rapide-dExcel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bot\u00e3o de formata\u00e7\u00e3o autom\u00e1tica na barra de ferramentas de acesso r\u00e1pido do Excel\"><\/figure><\/div><p> Agora voc\u00ea tem o \u00edcone de formata\u00e7\u00e3o autom\u00e1tica na barra de ferramentas de acesso r\u00e1pido.<\/p><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> Como usar a formata\u00e7\u00e3o autom\u00e1tica?<\/h2><p> Aplicar formatos com op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica \u00e9 super simples. Digamos que voc\u00ea queira formatar a tabela de dados abaixo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/table-de-donnees-pour-utiliser-le-format-automatique-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tabela de dados para usar a formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formatage-automatique-des-donnees.xlsx\" rel=\"nofollow\">Baixe este arquivo aqui<\/a> para seguir e seguir as etapas abaixo para formatar a tabela.<\/p><ul><li> Selecione uma das c\u00e9lulas em seus dados. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-nimporte-quelle-cellule-des-donnees-pour-appliquer-le-formatage-avec-le-format-automatique-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"selecione qualquer c\u00e9lula nos dados para aplicar a formata\u00e7\u00e3o com formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><ul><li> V\u00e1 para a barra de ferramentas de acesso r\u00e1pido e clique no bot\u00e3o Formata\u00e7\u00e3o autom\u00e1tica. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-le-bouton-de-formatage-automatique-pour-ajouter-un-formatage-sur-la-table-de-donnees-min-1.png\" sizes=\"\" srcset=\"\" alt=\"clique no bot\u00e3o de formata\u00e7\u00e3o autom\u00e1tica para adicionar formata\u00e7\u00e3o na tabela de dados\"><\/figure><\/div><ul><li> Agora voc\u00ea tem uma janela onde voc\u00ea tem diferentes formatos de dados.<\/li><li> Selecione um e clique em OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-le-format-et-cliquez-sur-OK-pour-appliquer-le-formatage-avec-le-format-automatique-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"selecione o formato e clique em OK para aplicar a formata\u00e7\u00e3o com formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><ul><li> Depois de clicar em OK, o formato escolhido ser\u00e1 aplicado instantaneamente aos dados. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-formate-avec-format-automatique-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tabela formatada com formata\u00e7\u00e3o autom\u00e1tica no excel\"><\/figure><\/div><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> Como alterar um formato para formato autom\u00e1tico?<\/h2><p> Como mencionei acima, todos os formatos na Formata\u00e7\u00e3o Autom\u00e1tica s\u00e3o uma combina\u00e7\u00e3o de 6 componentes diferentes. E voc\u00ea tamb\u00e9m pode adicionar ou remover esses componentes de cada formato antes de aplic\u00e1-los.<\/p><p> Digamos que voc\u00ea queira adicionar formata\u00e7\u00e3o \u00e0 tabela de dados abaixo, mas sem alterar o estilo da fonte e a largura da coluna. Voc\u00ea precisa aplicar o formato seguindo as etapas abaixo.<\/p><ul><li> Selecione seus dados e clique no bot\u00e3o de formata\u00e7\u00e3o autom\u00e1tica.<\/li><li> Selecione um formato a ser aplicado e clique no bot\u00e3o \u201cOp\u00e7\u00f5es\u201d.<\/li><li> Nas op\u00e7\u00f5es, desmarque \u201cFonte\u201d e \u201cLargura\/Altura\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modifier-le-format-au-format-automatique-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"alterar formato para formata\u00e7\u00e3o autom\u00e1tica no Excel\"><\/figure><\/div><ul><li> E clique em OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-sans-style-de-police-et-largeur-avec-format-automatique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"formatar sem estilo de fonte e largura com formata\u00e7\u00e3o autom\u00e1tica\"><\/figure><\/div><p> Agora, ambos os componentes n\u00e3o est\u00e3o presentes na sua formata\u00e7\u00e3o.<\/p><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> Removendo formata\u00e7\u00e3o<\/h2><p> Bem, para remover a formata\u00e7\u00e3o de dados, a melhor maneira \u00e9 usar uma tecla de atalho Alt + H + E + F. Mas voc\u00ea tamb\u00e9m pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica para remover a formata\u00e7\u00e3o de seus dados.<\/p><ul><li> Selecione todos os seus dados e abra a formata\u00e7\u00e3o autom\u00e1tica.<\/li><li> V\u00e1 para o \u00faltimo da lista de formatos onde voc\u00ea possui o formato \u201cNenhum\u201d. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/supprimer-le-format-avec-le-format-automatique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"remover formato com formata\u00e7\u00e3o autom\u00e1tica\"><\/figure><\/div><ul><li> Selecione-o e clique em OK.<\/li><\/ul><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> Pontos importantes<\/h2><ol><li> A formata\u00e7\u00e3o autom\u00e1tica n\u00e3o \u00e9 capaz de reconhecer se voc\u00ea j\u00e1 possui formata\u00e7\u00e3o em seus dados. Ele ir\u00e1 ignorar e aplicar a nova formata\u00e7\u00e3o de acordo com o formato que voc\u00ea selecionou.<\/li><li> Voc\u00ea precisa de pelo menos 2 c\u00e9lulas para aplicar a formata\u00e7\u00e3o com a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica.<\/li><\/ol><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\/excel-avancado\/\">Tutoriais avan\u00e7ados de Excel<\/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\/formulas-1\/\" data-wpil=\"url\">F\u00f3rmulas em formata\u00e7\u00e3o condicional<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/destacar-linhas-alternadas\/\">Destaque linhas alternativas no Excel com amostra de cores<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/jogos-de-icones\/\" data-wpil=\"url\">Use conjuntos de \u00edcones no Excel (formata\u00e7\u00e3o condicional)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/melhores-fontes\/\">Melhores fontes para Microsoft Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/ocultar-zeros\/\">Ocultar valores zero 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-289","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>Formato Excel autom\u00e1tico | Op\u00e7\u00e3o de formata\u00e7\u00e3o para economizar tempo<\/title>\n<meta name=\"description\" content=\"Se n\u00e3o quiser gastar tempo e esfor\u00e7o formatando seus dados, voc\u00ea pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica que oferece 16 formatos diferentes.\" \/>\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\/formatacao-automatica\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formato Excel autom\u00e1tico | Op\u00e7\u00e3o de formata\u00e7\u00e3o para economizar tempo\" \/>\n<meta property=\"og:description\" content=\"Se n\u00e3o quiser gastar tempo e esfor\u00e7o formatando seus dados, voc\u00ea pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica que oferece 16 formatos diferentes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:44:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.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=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/\",\"name\":\"Formato Excel autom\u00e1tico | Op\u00e7\u00e3o de formata\u00e7\u00e3o para economizar tempo\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png\",\"datePublished\":\"2023-11-06T11:11:53+00:00\",\"dateModified\":\"2023-12-06T11:44:00+00:00\",\"description\":\"Se n\u00e3o quiser gastar tempo e esfor\u00e7o formatando seus dados, voc\u00ea pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica que oferece 16 formatos diferentes.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar a op\u00e7\u00e3o auto format 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":"Formato Excel autom\u00e1tico | Op\u00e7\u00e3o de formata\u00e7\u00e3o para economizar tempo","description":"Se n\u00e3o quiser gastar tempo e esfor\u00e7o formatando seus dados, voc\u00ea pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica que oferece 16 formatos diferentes.","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\/formatacao-automatica\/","og_locale":"pt_PT","og_type":"article","og_title":"Formato Excel autom\u00e1tico | Op\u00e7\u00e3o de formata\u00e7\u00e3o para economizar tempo","og_description":"Se n\u00e3o quiser gastar tempo e esfor\u00e7o formatando seus dados, voc\u00ea pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica que oferece 16 formatos diferentes.","og_url":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:44:00+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/","url":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/","name":"Formato Excel autom\u00e1tico | Op\u00e7\u00e3o de formata\u00e7\u00e3o para economizar tempo","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png","datePublished":"2023-11-06T11:11:53+00:00","dateModified":"2023-12-06T11:44:00+00:00","description":"Se n\u00e3o quiser gastar tempo e esfor\u00e7o formatando seus dados, voc\u00ea pode usar a op\u00e7\u00e3o de formata\u00e7\u00e3o autom\u00e1tica que oferece 16 formatos diferentes.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-la-liste-deroulante-pour-activer-le-format-automatique-dans-Excel-min-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/formatacao-automatica\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar a op\u00e7\u00e3o auto format 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\/289","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=289"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/289\/revisions"}],"predecessor-version":[{"id":1338,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/289\/revisions\/1338"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}