How to Delete All Empty Rows and Columns in Google Sheets

How to delete all empty rows and columns in Google Sheets-1

Google Sheets is the search giant’s free, online version of Excel. For the hardcore spreadsheet enthusiast it won’t be anywhere near powerful enough, but for those of us who just use them to track projects and make simple spreadsheets, it is ideal.

To aid familiarity, many features of Excel are replicated in Google Sheets. Many of the controls are similar and many of the ways of creating formulas are too. If you’re familiar with how Excel works, you should be able to pick up Sheets in no time at all.

One common thread between all spreadsheet software is the appearance of seemingly random empty cells, rows or columns. In smaller spreadsheets, this is easily manageable, but in larger ones it can become troublesome keeping them all in check. Fortunately, there are a few ways to delete all empty rows and columns in Google Sheets.

You can use keyboard shortcuts, Windows controls or use an app that can do much more than delete all empty rows and columns.

How to delete all empty rows and columns in Google Sheets-2

Shortcut keys to delete all empty rows and columns in Google Sheets

First, let us look at shortcut keys. These are ideal for smaller spreadsheets where the odd column or row needs deleting.

For PC

Delete row – Alt + E, then D for Chrome and Alt + Shift + E, then D for other browsers.

Delete column – Alt + E, then E for Chrome and Alt + Shift + E, then E for other browsers.

For Mac

Delete row – Ctrl + Option + E, then D

Delete column – Ctrl + Option + E, then E

How to delete all empty rows and columns in Google Sheets-3

Windows controls to delete all empty rows and columns in Google Sheets

If you use a Windows PC and know how to use Ctrl or Shift to select multiple cells at once, this will be instantly familiar. If you’re not familiar with Windows, try these.

Hold Ctrl and click the mouse on multiple rows or columns to select them all. Then right click and select ‘Delete selected rows/columns’.

If you are deleting a series of consecutive rows or columns, hold down the Shift key, click the first cell in the sequence and then the final cell. All should be highlighted. Right click and select ‘Delete selected rows/columns’.

Use an app to delete all empty rows and columns

There is an app available for Google Sheets that can remove blank rows and columns and has a few more tricks up its sleeve too. It is free and available from the Google Play Store.

Download and install as you see fit. The app will then add a control called ‘Remove Blank Rows’. It will then search the spreadsheet and delete all of them with a single click. It also allows you to undo any changes too, just in case.

Know any other way to delete all empty rows and columns in Google Sheets? Tell us about them below if you do!

Posted by Jamie on August 29, 2016

Leave a Reply

Your email address will not be published. Required fields are marked *