Tnhelearning.edu.vn - Various useful general information portal

How to Remove Blank Lines on Google Sheets (PC or Mac)

by Category: How To

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.

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.

Delete line by line

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 1

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 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-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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 2

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 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-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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 3

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 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-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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 4

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 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-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

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 5

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 5

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 6

READ More:   How to Fix Internet Connection Error

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 6

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 7

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 7

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 8

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 8

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 9

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 9

{“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 .
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 10

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 10

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 11

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 11

{“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

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 12

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 12

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 13

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 13

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 14

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 14

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 15

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 15

{“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 .
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 16

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 16

{“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
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 17

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 17

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 18

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 18

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 19

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 19

{“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 .
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 20

READ More:   How to Disable Internet Connection

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 20

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 21

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 21

{“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) .
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 22

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 22

{“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.
Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 23

Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 23

{“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.
  • Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 24

    Image titled Delete Empty Rows on Google Sheets on PC or Mac Step 24

    {“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.

    • 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:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks