{"id":3169,"date":"2023-01-04T09:15:29","date_gmt":"2023-01-04T12:15:29","guid":{"rendered":"http:\/\/wiki3.locaweb.com.br\/?post_type=ht_kb&#038;p=3169"},"modified":"2025-07-15T10:58:30","modified_gmt":"2025-07-15T13:58:30","slug":"como-excluir-linhas-vazias-do-excel-email-marketing","status":"publish","type":"ht_kb","link":"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/como-excluir-linhas-vazias-do-excel-email-marketing\/","title":{"rendered":"Como excluir linhas vazias do Excel em Email Marketing"},"content":{"rendered":"    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Informa\u00e7\u00e3o!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tEste artigo tem como objetivo auxiliar na edi\u00e7\u00e3o de arquivos em\u00a0<strong>Excel<\/strong>\u00a0(Deletar linhas vazias do Excel) para posterior\u00a0importa\u00e7\u00e3o\u00a0de Listas de contato no\u00a0<strong>Email Marketing<\/strong>.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<p>Veja as dicas abaixo:<\/p>\n<h2><b>V\u00eddeo<\/b><strong>\u00a0Tutorial<\/strong><\/h2>\n<p><iframe loading=\"lazy\" title=\"Como remover linhas vazias no Excel | Locaweb\" width=\"643\" height=\"362\" src=\"https:\/\/www.youtube.com\/embed\/2MqBj_Bi4xs?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2>1\u00ba M\u00e9todo &#8211; Recurso &#8220;Ir para especial&#8221;<\/h2>\n<ul>\n<li>Primeiramente, selecione as c\u00e9lulas que deseja eliminar (as linhas vazias).<\/li>\n<li>Ent\u00e3o v\u00e1 em\u00a0<b>Localizar e Selecionar <\/b>&gt;\u00a0<b>Ir para Especial<\/b>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23642\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2020\/12\/Execel-1.jpg\" alt=\"\" width=\"237\" height=\"294\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/Execel-1.jpg 237w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/Execel-1-40x50.jpg 40w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/Execel-1-48x60.jpg 48w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/Execel-1-81x100.jpg 81w\" sizes=\"auto, (max-width: 237px) 100vw, 237px\" \/><\/p>\n<ul>\n<li>Depois, selecione a op\u00e7\u00e3o\u00a0<strong>Em branco <\/strong>e d\u00ea<strong> OK<\/strong>. Essa op\u00e7\u00e3o selecionar\u00e1 as linhas em branco.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23643\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2020\/12\/execel-2.jpg\" alt=\"\" width=\"341\" height=\"320\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-2.jpg 341w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-2-300x282.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-2-50x47.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-2-60x56.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-2-100x94.jpg 100w\" sizes=\"auto, (max-width: 341px) 100vw, 341px\" \/><\/p>\n<ul>\n<li>Navegue at\u00e9 a aba <strong>P\u00e1gina Inicial<\/strong>,\u00a0clique em <strong>Excluir <\/strong>e\u00a0<strong>Excluir Linhas da Planilha<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23644\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2020\/12\/execel-3.jpg\" alt=\"\" width=\"440\" height=\"234\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-3.jpg 440w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-3-300x160.jpg 300w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-3-50x27.jpg 50w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-3-60x32.jpg 60w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-3-100x53.jpg 100w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/p>\n    \t\t<div class=\"hts-messages hts-messages--success  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Pronto!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tAs c\u00e9lulas vazias foram deletadas.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n    \t\t<div class=\"hts-messages hts-messages--alert  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><strong>Observa\u00e7\u00e3o!<\/strong><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\t<b>C<\/b>aso haja dados nas colunas que ser\u00e3o exclu\u00eddas por conter linhas vazias, esses dados ser\u00e3o deslocados, podendo gerar inconsist\u00eancia. \u00a0    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<h2>2\u00ba M\u00e9todo &#8211; Recurso &#8220;Filtro&#8221;<\/h2>\n<ul>\n<li>Primeiramente, selecione as c\u00e9lulas que deseja eliminar (as linhas vazias).<\/li>\n<li>Navegue at\u00e9 a\u00a0<b>P\u00e1gina Inicial <\/b>&gt;<b> Classificar e Filtrar <\/b>&gt;<b> Filtro<\/b>, ou pressione as teclas de atalho\u00a0<b>Shift + Ctrl + L<\/b>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23645\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2020\/12\/execel-4.jpg\" alt=\"\" width=\"295\" height=\"314\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-4.jpg 295w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-4-282x300.jpg 282w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-4-47x50.jpg 47w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-4-56x60.jpg 56w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-4-94x100.jpg 94w\" sizes=\"auto, (max-width: 295px) 100vw, 295px\" \/><\/p>\n<ul>\n<li>Em seguida, selecione uma coluna, clique no\u00a0<strong>filtro <\/strong>suspenso, desmarque todos os valores com exce\u00e7\u00e3o de\u00a0<strong>(Vazias)<\/strong>\u00a0e clique em\u00a0<strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23647\" src=\"https:\/\/ajuda.locaweb.com.br\/wp-content\/uploads\/2020\/12\/execel-5.jpg\" alt=\"\" width=\"268\" height=\"467\" srcset=\"https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-5.jpg 268w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-5-172x300.jpg 172w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-5-29x50.jpg 29w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-5-34x60.jpg 34w, https:\/\/www.locaweb.com.br\/ajuda\/wp-content\/uploads\/2020\/12\/execel-5-57x100.jpg 57w\" sizes=\"auto, (max-width: 268px) 100vw, 268px\" \/><\/p>\n<ul>\n<li>Navegue at\u00e9 a aba <strong>P\u00e1gina Inicial<\/strong>,\u00a0clique em <strong>Excluir <\/strong>e\u00a0<strong>Excluir Linhas da Planilha<\/strong>.<\/li>\n<\/ul>\n    \t\t<div class=\"hts-messages hts-messages--success  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Pronto!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tAs c\u00e9lulas vazias foram deletadas.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon \"   >\r\n    \t\t\t<span class=\"hts-messages__title\"><b>Conhe\u00e7a!<\/b><\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tVoc\u00ea aprendeu a deletar linhas vazias do Excel, agora aproveite e conhe\u00e7a outros produtos da Locaweb, como o <a class=\"waffle-rich-text-link\" href=\"https:\/\/www.locaweb.com.br\/email-profissional\/\" target=\"_blank\" rel=\"noopener\">Email Empresarial<\/a> e <a class=\"waffle-rich-text-link\" href=\"https:\/\/www.locaweb.com.br\/hospedagem-de-sites-com-dominio-gratis\/\" target=\"_blank\" rel=\"noopener\">Hospedagem de Sites<\/a>.    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<ul>\n<li aria-level=\"1\"><b>Leia tamb\u00e9m: Como corrigir o <\/b><a href=\"https:\/\/www.locaweb.com.br\/ajuda\/wiki\/erro-400\/\" target=\"_blank\" rel=\"noopener\"><b>erro 400<\/b><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veja as dicas abaixo: V\u00eddeo\u00a0Tutorial 1\u00ba M\u00e9todo &#8211; Recurso &#8220;Ir para especial&#8221; Primeiramente, selecione as c\u00e9lulas que deseja eliminar (as linhas vazias). Ent\u00e3o v\u00e1 em\u00a0Localizar e Selecionar &gt;\u00a0Ir para Especial. Depois, selecione a op\u00e7\u00e3o\u00a0Em branco e d\u00ea OK. Essa op\u00e7\u00e3o selecionar\u00e1 as linhas em branco. Navegue at\u00e9 a aba P\u00e1gina&#8230;<\/p>\n","protected":false},"author":6,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[128],"ht-kb-tag":[376],"class_list":["post-3169","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-email-marketing","ht_kb_tag-categoriaemail-marketing"],"_links":{"self":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/3169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/comments?post=3169"}],"version-history":[{"count":19,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/3169\/revisions"}],"predecessor-version":[{"id":37757,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb\/3169\/revisions\/37757"}],"wp:attachment":[{"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/media?parent=3169"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-category?post=3169"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.locaweb.com.br\/ajuda\/wp-json\/wp\/v2\/ht-kb-tag?post=3169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}