{"id":5326,"date":"2024-04-18T14:52:35","date_gmt":"2024-04-18T14:52:35","guid":{"rendered":"https:\/\/windowsreport.com\/pt\/?p=5326"},"modified":"2025-10-02T13:41:45","modified_gmt":"2025-10-02T10:41:45","slug":"filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes","status":"publish","type":"post","link":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/","title":{"rendered":"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es"},"content":{"rendered":"<p>A maioria dos usu\u00e1rios do Excel provavelmente configura tabelas de dados nesse aplicativo. Os usu\u00e1rios podem filtrar dados em suas tabelas com a ferramenta de filtragem do Excel. No entanto, \u00e0s vezes as tabelas da planilha do Excel podem n\u00e3o filtrar os dados corretamente.<\/p><p> Se voc\u00ea precisar corrigir a filtragem da tabela do Excel, verifique algumas das poss\u00edveis solu\u00e7\u00f5es abaixo.<\/p><h2 class=\"wp-block-heading\"> Como posso corrigir a filtragem da tabela do Excel?<\/h2><h3 class=\"wp-block-heading\"> 1. Selecione a coluna inteira para aplicar o filtro <\/h3><ol class=\"rm-how-to\"><h3 class=\"rm-how-to__block-title\" id=\"\"><\/h3><p>If Excel is not filtering the whole column in a spreadsheet, you can manually configure it to do this. What you need to do is select the column and tweak its filter settings.<\/p>\n<li class=\"rm-how-to__step\"><p>1. Launch Microsoft Excel.<\/p>\n<\/li><li class=\"rm-how-to__step\"><p>2. u003cspanu003eOpen the file where the filter is not working.u003c\/spanu003e<\/p>\n<\/li><li class=\"rm-how-to__step\"><p>3. u003cspanu003eSu003c\/spanu003eu003cspanu003eelect the table\u2019s whole spreadsheet column by clicking the column\u2019s letter.u003c\/spanu003e<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" style=\"max-width: 80%;width:px\" src=\"\" srcset=\"\" sizes=\"\" alt=\"\" \/><\/figure><\/div><\/li><li class=\"rm-how-to__step\"><p>4. Navigate to the u003cstrongu003eDatau003c\/strongu003e tab.<\/p>\n<\/li><li class=\"rm-how-to__step\"><p>5. Then click theu003cspanu003e\u00a0u003c\/spanu003eu003cstrongu003eFilteru003c\/strongu003eu003cspanu003e\u00a0u003c\/spanu003ebutton to apply the filter to the whole column.<\/p>\n<\/li><li class=\"rm-how-to__step\"><p>6. u003cspanu003eClick the cell filter arrow button to open the filtering options shown directly below.u003c\/spanu003e<\/p>\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" style=\"max-width: 80%;width:px\" src=\"\" srcset=\"\" sizes=\"\" alt=\"\" \/><\/figure><\/div><\/li><li class=\"rm-how-to__step\"><p>7. Uncheck theu003cspanu003e\u00a0u003c\/spanu003eu003cstrongu003eBlanksu003c\/strongu003eu003cspanu003e\u00a0u003c\/spanu003echeckbox. This setting will ensure that blank cells will not be filtered.<\/p>\n<\/li><li class=\"rm-how-to__step\"><p>8. Click on u003cstrongu003eOKu003c\/strongu003e to apply the changes.<\/p>\n<\/li><\/ol><script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\/\",\"@type\":\"HowTo\",\"name\":\"\",\"description\":\"If Excel is not filtering the whole column in a spreadsheet, you can manually configure it to do this. What you need to do is select the column and tweak its filter settings.\",\"totalTime\":\"\",\"difficulty\":false,\"tool\":[],\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"1. Launch Microsoft Excel.\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"2. u003cspanu003eOpen the file where the filter is not working.u003c\/spanu003e\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"3. u003cspanu003eSu003c\/spanu003eu003cspanu003eelect the table\\u2019s whole spreadsheet column by clicking the column\\u2019s letter.u003c\/spanu003e\"},\"image\":{\"@type\":\"ImageObject\",\"url\":null,\"width\":null,\"height\":null}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"4. Navigate to the u003cstrongu003eDatau003c\/strongu003e tab.\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"5. Then click theu003cspanu003e\\u00a0u003c\/spanu003eu003cstrongu003eFilteru003c\/strongu003eu003cspanu003e\\u00a0u003c\/spanu003ebutton to apply the filter to the whole column.\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"6. u003cspanu003eClick the cell filter arrow button to open the filtering options shown directly below.u003c\/spanu003e\"},\"image\":{\"@type\":\"ImageObject\",\"url\":null,\"width\":null,\"height\":null}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"7. Uncheck theu003cspanu003e\\u00a0u003c\/spanu003eu003cstrongu003eBlanksu003c\/strongu003eu003cspanu003e\\u00a0u003c\/spanu003echeckbox. This setting will ensure that blank cells will not be filtered.\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#rm-how-to-block_62fc9c43da029-\",\"itemListElement\":{\"@type\":\"HowToDirection\",\"text\":\"8. Click on u003cstrongu003eOKu003c\/strongu003e to apply the changes.\"}}]}<\/script><h3 class=\"wp-block-heading\">2. Exclua c\u00e9lulas em branco da coluna da tabela<\/h3><p> Como alternativa, voc\u00ea pode apagar linhas em branco da coluna de uma tabela para incluir valores abaixo das c\u00e9lulas vazias no filtro.<\/p><p> Selecione todas as linhas das c\u00e9lulas vazias segurando a tecla Ctrl. Em seguida, clique com o bot\u00e3o direito e selecione a op\u00e7\u00e3o <strong>Excluir<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-Delete-option-in-Excel.png\"><img decoding=\"async\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-Delete-option-in-Excel.png\" alt=\"Delete option excel spreadsheet not filtering correctly\" class=\"wp-image-449006\" title=\"A op\u00e7\u00e3o Excluir\" \/><\/a><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. Desagrupar planilhas<\/h3><p> A op\u00e7\u00e3o <strong>Filtro<\/strong> ficar\u00e1 esmaecida quando suas planilhas forem agrupadas. Portanto, voc\u00ea n\u00e3o pode filtrar tabelas de planilhas em planilhas agrupadas. Para corrigir isso, clique com o bot\u00e3o direito nas planilhas agrupadas na parte inferior do Excel e selecione <strong>Desagrupar planilhas<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/ungroup-sheets-option.png\"><img decoding=\"async\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/ungroup-sheets-option.png\" alt=\"Ungroup Sheets option excel spreadsheet not filtering correctly\" class=\"wp-image-449009\" title=\"A op\u00e7\u00e3o Desagrupar planilhas\" \/><\/a> <\/figure><\/div><hr class=\"wp-block-separator\" \/><h3 class=\"wp-block-heading\"> 4. Desproteja a planilha<\/h3><ol class=\"wp-block-list\"><li> Selecione a guia Revis\u00e3o do Excel.<\/li><li> Pressione o bot\u00e3o <strong>Desproteger planilha<\/strong> . <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-unprotect-sheet-button3.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" title=\"O bot\u00e3o Desproteger planilhas\" width=\"262\" height=\"151\" class=\"aligncenter wp-image-449000 size-full\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-unprotect-sheet-button3.png\" alt=\"Unprotect Sheet button excel spreadsheet not filtering correctly\"><\/a><\/li><li> Se uma janela Desproteger planilha for aberta, digite a senha da planilha na caixa de texto.<\/li><li> Clique no bot\u00e3o <strong>OK<\/strong> .<\/li><\/ol><h3 class=\"wp-block-heading\"> 5. Desfazer a mesclagem de c\u00e9lulas<\/h3><ol class=\"wp-block-list\"><li> Pressione a tecla de atalho Ctrl + F.<br> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/Find-and-Replace-window.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" title=\"A janela Localizar e Substituir\" width=\"445\" height=\"243\" class=\"aligncenter wp-image-449004 size-full\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/Find-and-Replace-window.png\" alt=\"Find and Replace window excel spreadsheet not filtering correctly\"><\/a><\/li><li> Clique no bot\u00e3o <strong>Formatar<\/strong> na janela Localizar e Substituir.<\/li><li> Clique em <strong>Mesclar c\u00e9lulas<\/strong> na guia Alinhamento mostrada diretamente abaixo. <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-Merge-cells-option.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" title=\"A op\u00e7\u00e3o Mesclar c\u00e9lulas\" width=\"509\" height=\"494\" class=\"aligncenter wp-image-449003 size-full\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-Merge-cells-option.png\" alt=\"The Merge cells setting excel spreadsheet not filtering correctly\"><\/a><\/li><li> Pressione o bot\u00e3o <strong>OK<\/strong> .<\/li><li> Pressione o bot\u00e3o <strong>Localizar tudo<\/strong> .<ul><li> Depois disso, a janela Localizar e Substituir listar\u00e1 todas as refer\u00eancias de c\u00e9lulas com c\u00e9lulas mescladas.<\/li><\/ul><\/li><li> Para desfazer a mesclagem de c\u00e9lulas mescladas, selecione uma c\u00e9lula mesclada.<\/li><li> Clique na op\u00e7\u00e3o <strong>Mesclar e centralizar<\/strong> na guia P\u00e1gina inicial.<\/li><li> Selecione a op\u00e7\u00e3o <strong>Desfazer mesclagem de c\u00e9lulas<\/strong> . <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/Unmerge-cells-option.png\"><img decoding=\"async\" title=\"A op\u00e7\u00e3o Desfazer mesclagem de c\u00e9lulas\" width=\"398\" height=\"235\" class=\"aligncenter wp-image-449002 size-full\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/Unmerge-cells-option.png\" alt=\"Unmerge Cells option excel spreadsheet not filtering correctly\"><\/a><\/li><\/ol><h3 class=\"wp-block-heading\">6. Configure um novo filtro<\/h3><ol class=\"wp-block-list\"><li> Se houver linhas na sua tabela que n\u00e3o foram filtradas, tente configurar um novo filtro. Para fazer isso, selecione a guia Dados.<\/li><li> Clique no bot\u00e3o <strong>Limpar<\/strong> no grupo Classificar e Filtrar.<\/li><li> Em seguida, selecione todo o intervalo de colunas da tabela com o cursor.<\/li><li> Clique no bot\u00e3o <strong>Filtrar<\/strong> na guia Dados do Excel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter\"> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-filter-option.png\"><img decoding=\"async\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/the-filter-option.png\" alt=\"The Filter option excel spreadsheet not filtering correctly\" class=\"wp-image-449001\" title=\"O bot\u00e3o Filtrar\" \/><\/a><\/figure><\/div><p> Essas s\u00e3o algumas das resolu\u00e7\u00f5es que podem corrigir os filtros da tabela do Excel. Na maioria dos casos, reaplicar filtros ou limp\u00e1-los para configurar novos filtros geralmente resolver\u00e1 problemas de filtragem do Excel.<\/p><p> Qual das solu\u00e7\u00f5es resolveu o problema de filtragem pr\u00f3-Excel para voc\u00ea? Deixe-nos saber deixando uma mensagem na se\u00e7\u00e3o de coment\u00e1rios abaixo.<\/p><p> <strong>ARTIGOS RELACIONADOS PARA VERIFICAR:<\/strong><\/p><ul class=\"wp-block-list\"><li> <a href=\"https:\/\/windowsreport.com\/excel-sharing-violation-error\/\" target=\"_blank\" rel=\"noopener noreferrer\">Como corrigir erro de viola\u00e7\u00e3o de compartilhamento do Excel<\/a><\/li><li> <a href=\"https:\/\/windowsreport.com\/file-not-loaded-completely-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Como corrigir erro de arquivo n\u00e3o carregado completamente do Microsoft Excel<\/a><\/li><li><a href=\"https:\/\/windowsreport.com\/excel-cant-add-cells\/\" target=\"_blank\" rel=\"noopener noreferrer\">O Microsoft Excel n\u00e3o consegue adicionar novas c\u00e9lulas? Confira essas dicas<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>A maioria dos usu\u00e1rios do Excel provavelmente configura tabelas de dados nesse aplicativo. Os usu\u00e1rios podem filtrar dados em suas tabelas com a ferramenta de filtragem do Excel. No entanto, \u00e0s vezes as tabelas da planilha do Excel podem n\u00e3o filtrar os dados corretamente. Se voc\u00ea precisar corrigir a filtragem da tabela do Excel, verifique [&hellip;]<\/p>\n","protected":false},"author":2284,"featured_media":5327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_enabled_clarity":"","footnotes":""},"categories":[55],"tags":[184],"work":[],"class_list":["post-5326","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es - WindowsReport<\/title>\n<meta name=\"description\" content=\"Para corrigir uma planilha do Excel que n\u00e3o filtra corretamente, desagrupe suas planilhas, aplique o filtro a toda a coluna da planilha e desfa\u00e7a a mesclagem das c\u00e9lulas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es\" \/>\n<meta property=\"og:description\" content=\"Para corrigir uma planilha do Excel que n\u00e3o filtra corretamente, desagrupe suas planilhas, aplique o filtro a toda a coluna da planilha e desfa\u00e7a a mesclagem das c\u00e9lulas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/\" \/>\n<meta property=\"og:site_name\" content=\"WindowsReport\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-18T14:52:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-02T10:41:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/04\/shutterstock_699112366-Copy.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Guilherme Rodolfo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Guilherme Rodolfo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/\"},\"author\":{\"name\":\"Guilherme Rodolfo\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/person\\\/1238815d33479055e23a293a045b4310\"},\"headline\":\"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es\",\"datePublished\":\"2024-04-18T14:52:35+00:00\",\"dateModified\":\"2025-10-02T10:41:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/\"},\"wordCount\":493,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/04\\\/shutterstock_699112366-Copy.jpg\",\"keywords\":[\"excel\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/\",\"name\":\"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es - WindowsReport\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/04\\\/shutterstock_699112366-Copy.jpg\",\"datePublished\":\"2024-04-18T14:52:35+00:00\",\"dateModified\":\"2025-10-02T10:41:45+00:00\",\"description\":\"Para corrigir uma planilha do Excel que n\u00e3o filtra corretamente, desagrupe suas planilhas, aplique o filtro a toda a coluna da planilha e desfa\u00e7a a mesclagem das c\u00e9lulas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#primaryimage\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/04\\\/shutterstock_699112366-Copy.jpg\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/04\\\/shutterstock_699112366-Copy.jpg\",\"width\":1200,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#website\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/\",\"name\":\"WindowsReport\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#organization\",\"name\":\"WindowsReport\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/wr-logo-default-1.png\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/wr-logo-default-1.png\",\"width\":214,\"height\":35,\"caption\":\"WindowsReport\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/person\\\/1238815d33479055e23a293a045b4310\",\"name\":\"Guilherme Rodolfo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g\",\"caption\":\"Guilherme Rodolfo\"},\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/author\\\/guilhermerodolfo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es - WindowsReport","description":"Para corrigir uma planilha do Excel que n\u00e3o filtra corretamente, desagrupe suas planilhas, aplique o filtro a toda a coluna da planilha e desfa\u00e7a a mesclagem das c\u00e9lulas.","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:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/","og_locale":"pt_PT","og_type":"article","og_title":"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es","og_description":"Para corrigir uma planilha do Excel que n\u00e3o filtra corretamente, desagrupe suas planilhas, aplique o filtro a toda a coluna da planilha e desfa\u00e7a a mesclagem das c\u00e9lulas.","og_url":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/","og_site_name":"WindowsReport","article_published_time":"2024-04-18T14:52:35+00:00","article_modified_time":"2025-10-02T10:41:45+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/04\/shutterstock_699112366-Copy.jpg","type":"image\/jpeg"}],"author":"Guilherme Rodolfo","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Guilherme Rodolfo","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#article","isPartOf":{"@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/"},"author":{"name":"Guilherme Rodolfo","@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/person\/1238815d33479055e23a293a045b4310"},"headline":"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es","datePublished":"2024-04-18T14:52:35+00:00","dateModified":"2025-10-02T10:41:45+00:00","mainEntityOfPage":{"@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/"},"wordCount":493,"commentCount":0,"publisher":{"@id":"https:\/\/windowsreport.com\/pt\/#organization"},"image":{"@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#primaryimage"},"thumbnailUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/04\/shutterstock_699112366-Copy.jpg","keywords":["excel"],"articleSection":["Tutoriais"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/windowsreport.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/","url":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/","name":"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es - WindowsReport","isPartOf":{"@id":"https:\/\/windowsreport.com\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#primaryimage"},"image":{"@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#primaryimage"},"thumbnailUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/04\/shutterstock_699112366-Copy.jpg","datePublished":"2024-04-18T14:52:35+00:00","dateModified":"2025-10-02T10:41:45+00:00","description":"Para corrigir uma planilha do Excel que n\u00e3o filtra corretamente, desagrupe suas planilhas, aplique o filtro a toda a coluna da planilha e desfa\u00e7a a mesclagem das c\u00e9lulas.","breadcrumb":{"@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#primaryimage","url":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/04\/shutterstock_699112366-Copy.jpg","contentUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/04\/shutterstock_699112366-Copy.jpg","width":1200,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/windowsreport.com\/pt\/filtro-do-excel-nao-esta-funcionando-corretamente-use-essas-correcoes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/windowsreport.com\/pt\/"},{"@type":"ListItem","position":2,"name":"Filtro do Excel n\u00e3o est\u00e1 funcionando corretamente? Use essas corre\u00e7\u00f5es"}]},{"@type":"WebSite","@id":"https:\/\/windowsreport.com\/pt\/#website","url":"https:\/\/windowsreport.com\/pt\/","name":"WindowsReport","description":"","publisher":{"@id":"https:\/\/windowsreport.com\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/windowsreport.com\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/windowsreport.com\/pt\/#organization","name":"WindowsReport","url":"https:\/\/windowsreport.com\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/01\/wr-logo-default-1.png","contentUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/01\/wr-logo-default-1.png","width":214,"height":35,"caption":"WindowsReport"},"image":{"@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/person\/1238815d33479055e23a293a045b4310","name":"Guilherme Rodolfo","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g","caption":"Guilherme Rodolfo"},"url":"https:\/\/windowsreport.com\/pt\/author\/guilhermerodolfo\/"}]}},"_links":{"self":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts\/5326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/users\/2284"}],"replies":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/comments?post=5326"}],"version-history":[{"count":1,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts\/5326\/revisions"}],"predecessor-version":[{"id":5328,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts\/5326\/revisions\/5328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/media\/5327"}],"wp:attachment":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/media?parent=5326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/categories?post=5326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/tags?post=5326"},{"taxonomy":"work","embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/work?post=5326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}