Delete Blank Rows in Google Sheets: A Step-by-Step Guide

Learn the quickest way to remove blank rows in Google Sheets - perfect for keeping your spreadsheets clean and organized.

1 min readGoogle Sheets
Contents
  1. Method 1: Manual Removal (Perfect for Small Datasets)
  2. Method 2: Using Filters (Better for Larger Datasets)

When dealing with a small dataset in Google Sheets, manually removing empty rows can be quicker than setting up complex tools or formulas. Let me show you how to handle those pesky blank rows, both manually and using filters.

Let's work with this sample data to make it crystal clear:

Sample Google Sheets data listing name, sales and region, with an empty row between each entry.

Method 1: Manual Removal (Perfect for Small Datasets)

  • Open your spreadsheetsome textLook for empty rows scattered through your data
  • Select Multiple Empty RowsPress and hold Ctrl (if you're on Mac, use Command)Click each row number on the left that's emptyYou'll see them highlight in blue as you click
Empty rows 3, 5, 7 and 9 selected together in Google Sheets, highlighted in blue before deletion.
  • Remove the RowsRight-click any of the blue-highlighted row numbersLook for "Delete selected rows" in the menu that pops upClick it to remove all selected rows at once
Google Sheets right-click menu on blank row 3 with the Delete row option highlighted.

Method 2: Using Filters (Better for Larger Datasets)

When you're dealing with a larger spreadsheet, filters become your best friend. They can either hide empty rows temporarily or help you identify them for deletion. Here's how:

  • Select Your Data RangeClick and drag from the first cell to the lastInclude all columns and rows, even the empty ones
Google Sheets data range A1:A10 selected, including the blank rows, before adding a filter.
  • Add Your FilterFind the filter icon (looks like a funnel) in the toolbarClick it to activate filters
Google Sheets filter turned on for the data range, with an arrow pointing to the filter icon in header cell A1.
  • Filter Out Empty RowsClick any column's filter arrowGo to "Filter by condition"Choose "Is not empty"Click "OK"
Google Sheets filter menu with Filter by condition set to 'Is not empty' to hide the blank rows.

Pro tip: Before you start deleting rows, especially in a large spreadsheet, make a copy of your sheet. This gives you a safety net in case you need to revert any changes.

Let’s make AP
work for you.