Removing empty rows in Google Sheets

How to remove empty rows from a Google Sheet using the Remove Empty Rows addon

Feb 18, 2024 | Read time 1 minutes

🔔 Table of contents

1. Introduction

Have you ever needed to remove empty rows from your Google Sheet without resorting to coding up AppScript?

I have created a Google Addon - Remove Empty Rows that will do just that.

In this article, I will go over on how to use it.

2. Installing the Addon

Firstly this Addon will only work with Google Sheets product. You will need to install it first before using - just go through the usual steps of installing Google Addons.

3. How to remove empty rows from your sheet

After we have done the installation, just open up a Google Sheet that you want to process.

You should see the addon in the menu as "Remove Empty Rows".

There are two options available:

  • Remove from selection - this will remove the empty rows within your current selection
  • Remove all from sheet - this will remove the empty rows in your sheet. You do not have to select any data!

👋 About the Author

G'day! I am Huy a software engineer based in Australia. I have been creating design-centered software for the last 10 years both professionally and as a passion.

My aim to share what I have learnt with you! (and to help me remember 😅)

Follow along on Twitter , GitHub and YouTube