Como Excluir Linhas Vazias no Google Planilhas no Windows ou Mac

Baixe em PDF
Coescrito por Equipe wikiHow

Baixe em PDF

Este artigo vai ensiná-lo a excluir linhas vazias em um documento do "Google Planilhas" usando três métodos diferentes. Você pode fazê-lo de forma individual usando um filtro, ou em massa por meio de um add-on.

Método 1
Método 1 de 3:

Excluindo linhas individualmente

Baixe em PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e2\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e2\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Acesse o site https://sheets.google.com em um navegador de internet. Se sua conta estiver aberta, você verá uma lista de todos os documentos salvos nela.
    • Acesse sua conta do Google caso ainda não o tenha feito.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/39\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/39\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/ff\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/ff\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    As linhas são numeradas na coluna cinza do lado esquerdo.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/30\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/30\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Publicidade
Método 2
Método 2 de 3:

Usando um filtro

Baixe em PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Acesse o site https://sheets.google.com em um navegador de internet. Se sua conta estiver aberta, você verá uma lista de todos os documentos salvos nela.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a6\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a6\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b5\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b5\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1a\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1a\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/70\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/52\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/01\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Fazê-lo vai mover todas as células vazias para o final.
    Publicidade
Método 3
Método 3 de 3:

Usando um add-on

Baixe em PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Acesse o site https://sheets.google.com em um navegador de internet. Se sua conta estiver aberta, você verá uma lista de todos os documentos salvos nela.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fa\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fa\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-14.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8d\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8d\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d8\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-16.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-17.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Esse complemento tem o ícone de uma borracha.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/de\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/de\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-18.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Caso tenha múltiplas contas abertas, pode ser preciso selecionar em qual delas você deseja aplicar o complemento.
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-19.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4f\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4f\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-20.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/75\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/75\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-21.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5c\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-22.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Fazê-lo vai abrir as opções do complemento em uma coluna no lado direito.
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/61\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/61\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-23.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Em seguida, a planilha inteira será selecionada.
    • Também é possível pressionar o atalho Ctrl + A para selecionar tudo.
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg\/v4-460px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cc\/Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg\/v4-728px-Delete-Empty-Rows-on-Google-Sheets-on-PC-or-Mac-Step-24.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Publicidade

WikiHows Relacionados

Como
Obter o Microsoft Office Gratuitamente
5 Formas de Desativar o Modo Escuro no Microsoft Word
Como
Visualizar Senhas Salvas no Gerenciador de Credenciais do Windows
Como
Abrir Arquivos EPUB
Como
Inserir o Símbolo X Barra no Word
Como Impedir que Seu Status do Teams Fique como Ausente Automaticamente: 6 Formas
Como
Remover Zeros à Esquerda e à Direita dos Números no Excel
Como
Executar um Arquivo Java .Jar
Como Manter o Status do Microsoft Teams Ativo e Não Ficar Ausente
Como
Remover os Espaços entre Caracteres e Números no Excel
Como
Trocar uma Vírgula por um Ponto no Excel
Como
Ativar e Desativar o Leitor de PDF do Chrome no Windows e Mac
Como Inserir Data e Hora Automaticamente no Planilhas Google: Scripts, Fórmulas e Atalhos
Como
Inserir uma Marca de Verificação no Excel
Publicidade

Sobre este guia wikiHow

Em outras línguas
Esta página foi acessada 56 272 vezes.

Este artigo foi útil?

Publicidade