{"id":4747,"date":"2023-07-08T09:04:18","date_gmt":"2023-07-08T09:04:18","guid":{"rendered":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/"},"modified":"2023-07-08T09:04:18","modified_gmt":"2023-07-08T09:04:18","slug":"excel-preencher-celulas-vazias","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/","title":{"rendered":"Como preencher c\u00e9lulas em branco no excel (exemplo passo a passo)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Freq\u00fcentemente, voc\u00ea pode querer preencher c\u00e9lulas vazias em uma planilha do Excel com os valores das c\u00e9lulas diretamente acima delas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Por exemplo, voc\u00ea pode preencher c\u00e9lulas vazias no seguinte conjunto de dados:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-37053\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matchm4.png\" alt=\"Excel preenche c\u00e9lulas vazias\" width=\"646\" height=\"380\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Felizmente, isso \u00e9 f\u00e1cil de fazer usando a ferramenta <strong>Ir para especial<\/strong> do Excel e o exemplo passo a passo a seguir mostra como fazer isso.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Passo 1: Insira os dados<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Vamos come\u00e7ar inserindo os valores do seguinte conjunto de dados no Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37052 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb1.png\" alt=\"\" width=\"456\" height=\"399\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Etapa 2: selecione todas as c\u00e9lulas em branco<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Em seguida, destaque o intervalo de c\u00e9lulas <strong>A1:B13<\/strong> e clique no \u00edcone <strong>Localizar e selecionar<\/strong> no grupo <strong>Edi\u00e7\u00e3o<\/strong> na guia P\u00e1gina <strong>inicial<\/strong> e clique em <strong>Ir para especial<\/strong> no menu suspenso:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37054 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb2.png\" alt=\"\" width=\"527\" height=\"327\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Na nova janela que aparece, clique no bot\u00e3o pr\u00f3ximo a <strong>Espa\u00e7os em branco<\/strong> e clique em <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37055 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb3.png\" alt=\"\" width=\"349\" height=\"425\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Depois de clicar em <strong>OK<\/strong> , todos os valores vazios do intervalo ser\u00e3o selecionados:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37056 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb4.png\" alt=\"\" width=\"466\" height=\"394\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Etapa 3: preencha todas as c\u00e9lulas em branco<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Com todas as c\u00e9lulas vazias ainda selecionadas, digite \u201c <strong>=<\/strong> \u201d e digite a <strong>seta para cima<\/strong> no teclado.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Em seguida, clique em <strong>Ctrl<\/strong> + <strong>Enter<\/strong> ao mesmo tempo.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cada uma das c\u00e9lulas vazias ser\u00e1 preenchida:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37057 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirb5.png\" alt=\"\" width=\"449\" height=\"422\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Observe que todas as c\u00e9lulas vazias nas colunas <strong>Equipe<\/strong> e <strong>Jogador<\/strong> foram preenchidas com o valor apropriado das c\u00e9lulas acima delas.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir explicam como realizar outras tarefas comuns no Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pt\/excel-ignorar-na\/\" target=\"_blank\" rel=\"noopener\">Como ignorar valores #N\/A ao usar f\u00f3rmulas no Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/excel-substituir-na\/\" target=\"_blank\" rel=\"noopener\">Como substituir valores #N\/A no Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/erro-de-nome-do-excel\/\" target=\"_blank\" rel=\"noopener\">Como corrigir o erro #NAME no Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Freq\u00fcentemente, voc\u00ea pode querer preencher c\u00e9lulas vazias em uma planilha do Excel com os valores das c\u00e9lulas diretamente acima delas. Por exemplo, voc\u00ea pode preencher c\u00e9lulas vazias no seguinte conjunto de dados: Felizmente, isso \u00e9 f\u00e1cil de fazer usando a ferramenta Ir para especial do Excel e o exemplo passo a passo a seguir mostra [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4747","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como preencher c\u00e9lulas em branco no Excel (exemplo passo a passo) - Estatologia<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como preencher c\u00e9lulas vazias no Excel, com um exemplo passo a passo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como preencher c\u00e9lulas em branco no Excel (exemplo passo a passo) - Estatologia\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como preencher c\u00e9lulas vazias no Excel, com um exemplo passo a passo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T09:04:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matchm4.png\" \/>\n<meta name=\"author\" content=\"Dr. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/\",\"url\":\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/\",\"name\":\"Como preencher c\u00e9lulas em branco no Excel (exemplo passo a passo) - Estatologia\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-08T09:04:18+00:00\",\"dateModified\":\"2023-07-08T09:04:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como preencher c\u00e9lulas vazias no Excel, com um exemplo passo a passo.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como preencher c\u00e9lulas em branco no excel (exemplo passo a passo)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como preencher c\u00e9lulas em branco no Excel (exemplo passo a passo) - Estatologia","description":"Este tutorial explica como preencher c\u00e9lulas vazias no Excel, com um exemplo passo a passo.","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:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/","og_locale":"pt_PT","og_type":"article","og_title":"Como preencher c\u00e9lulas em branco no Excel (exemplo passo a passo) - Estatologia","og_description":"Este tutorial explica como preencher c\u00e9lulas vazias no Excel, com um exemplo passo a passo.","og_url":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/","og_site_name":"Statorials","article_published_time":"2023-07-08T09:04:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/matchm4.png"}],"author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/","url":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/","name":"Como preencher c\u00e9lulas em branco no Excel (exemplo passo a passo) - Estatologia","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-08T09:04:18+00:00","dateModified":"2023-07-08T09:04:18+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como preencher c\u00e9lulas vazias no Excel, com um exemplo passo a passo.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/excel-preencher-celulas-vazias\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como preencher c\u00e9lulas em branco no excel (exemplo passo a passo)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4747","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=4747"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4747\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=4747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=4747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=4747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}