Lege rijen verwijderen in Google Spreadsheets

Pdf downloaden
Bijdragen van wikiHow-redactie

Pdf downloaden

Deze wikiHow leert je drie manieren om lege rijen te verwijderen in Google Sheets. Je kunt lege rijen verwijderen door ze ieder apart te verwijderen, met behulp van een filter, of met een add-on voor het verwijderen van alle lege rijen en cellen.

Methode 1
Methode 1 van 3:

Afzonderlijke rijen verwijderen

Pdf downloaden
  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>"}
    Ga naar https://sheets.google.com in een webbrowser. Als je bent ingelogd bij Google, dan krijg je een lijst te zien met Google Sheets-documenten die gekoppeld zijn aan je account.
  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>"}
    Rijen worden genummerd in de grijze kolom aan de linkerkant.
  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>"}
    Advertentie
Methode 2
Methode 2 van 3:

Een filter gebruiken

Pdf downloaden
  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>"}
    Ga naar https://sheets.google.com in een web browser. Als je bent ingelogd op je Google-account, dan verschijnt er een lijst met de Google Sheet-documenten gekoppeld aan je account.
  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>"}
    Dit vind je in de menu-balk bovenaan.
  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>"}
    Hiermee verplaats je alle lege cellen naar beneden.
    Advertentie
Methode 3
Methode 3 van 3:

Een add-on gebruiken

Pdf downloaden
  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>"}
    Ga naar https://sheets.google.com in een webbrowser. Als je bent ingelogd op je Google-account, dan verschijnt er een lijst met Google Sheet-documenten gekoppeld aan je account.
  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>"}
    Dit vind je in de menubalk bovenaan.
  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>"}
    Deze knop vind je tegenover 'Remove Blank Rows (and more)'. Deze add-on wordt afgebeeld als een gum.
  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>"}
    Heb je meerdere Google-accounts, dan kan je gevraagd worden op welke account je de Add-on wilt toepassen.
  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>"}
    Dit vind je in de menubalk bovenaan.
  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>"}
    Hiermee open je de opties van de add-on in een kolom aan de rechterkant.
  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>"}
    Hiermee selecteer je de hele spreadsheet.
    • Je kunt ook op Ctrl + A drukken om alles te selecteren.
  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>"}
    Dit vind je in de opties van de add-on voor ' Remove Blank Rows (and more)'.
    Advertentie

Gerelateerde artikelen

Een lege pagina in Word verwijderen
Tekst doorhalen in Word
Een komma veranderen in een punt in Excel
De beveiliging verwijderen van een Excel bestand
Het eurosymbool typen
Twee Excel bestanden vergelijken
Een krant maken in Word
Verborgen rijen weer zichtbaar maken in Excel
Getallen van elkaar aftrekken in Excel
Een tekstvak maken in Google Documenten
Opmerkingen verwijderen of verbergen in een Worddocument
Twee spreadsheets samenvoegen in Excel
Advertentie

Over dit artikel

In andere talen
Deze pagina is 12.304 keer bekeken.

Was dit artikel nuttig?

Advertentie