You are viewing the article How to Remove Blank Lines on Google Sheets (PC or Mac) at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by wikiHow writer Rain Kengly. Rain Kengly is wikiHow’s technology writer. As a lover of technology storytelling, Rain wants to create lasting connections with readers around the world. Rain holds a bachelor’s degree in Film from the University of San Francisco.
This article has been viewed 16,560 times.
This wikiHow teaches you how to remove blank lines on Google Sheets in three ways. You can delete individual lines with filters, or delete entire lines and empty cells with add-ons.
Steps
Delete line by line
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Go to https://sheets.google.com on a web browser. If you’re signed in to Google, a list of Google Sheets documents associated with your account will appear.
- If you’re not already signed in to Google, sign in to continue.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the Google Sheets document.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Right click on the line number. Lines are numbered in the left gray column.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Delete Row .
Use filter
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Go to https://sheets.google.com on a web browser. If you’re signed in to Google, a list of Google Sheets documents associated with your account will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the Google Sheets document.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click and drag to select all data.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the Data tab in the top menu bar.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Filter .
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the green 3-line triangle icon in the upper left box.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Sort A → Z (Sort Alphabetically). All empty cells will be moved to the bottom.
Use add-ons
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Go to https://sheets.google.com on a web browser. If you’re signed in to Google, a list of Google Sheets documents associated with your account will appear.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the Google Sheets document.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the Add-ons tab in the top menu bar.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Get Add-ons .
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Type Remove Blank Rows in the search bar and press Enter
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click + Free (+ Free). This button is in the same line on the other side of the name “Remove Blank Rows (and More)”. The widget is shaped like an eraser.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click your Google account. If you have more than one account, Google will ask you which account you want to add the add-on to.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Allow .
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the Add-ons tab in the top menu bar again.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Select Remove Blank Rows (and More) .
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Delete Blank Rows/Cpumns . The add-on options will open in the right column.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click the empty gray cell in the upper left of the spreadsheet. The entire workbook will be selected.
- You can also press Ctrl + A to select all.
{“smallUrl”:”https://www.wikihow.com/images_en/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”,”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>”}
Click Delete . The task is in the “Remove Blank Rows (and More)” add-on options column.
X
This article is co-authored by wikiHow writer Rain Kengly. Rain Kengly is wikiHow’s technology writer. As a lover of technology storytelling, Rain wants to create lasting connections with readers around the world. Rain holds a bachelor’s degree in Film from the University of San Francisco.
This article has been viewed 16,560 times.
This wikiHow teaches you how to remove blank lines on Google Sheets in three ways. You can delete individual lines with filters, or delete entire lines and empty cells with add-ons.
Thank you for reading this post How to Remove Blank Lines on Google Sheets (PC or Mac) at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: