Learn how to get Free YouTube subscribers, views and likes

Get Free YouTube Subscribers, Views and Likes

How to delete all blank rows in Excel in 3 seconds

Follow

The Tech Train

If you have multiple blank rows in a spreadsheet it can be very timeconsuming to try to delete them either individually, or selecting them and then deleting them. In this quick tutorial I'll show you a very easy way to delete every blank row in a table or entire spreadsheet in under three seconds flat.

posted by axayya

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

Stop using VLOOKUP in Excel. Switch to INDEX MATCH

3 Easy Ways to Delete Blank Rows in Excel ✅

3 Easy Ways to Delete Blank Rows in Excel ✅

Three EASY Ways to Find and Remove Duplicates in Excel

Three EASY Ways to Find and Remove Duplicates in Excel

Excel Tips Hide or Remove All Unused Rows and Columns in Excel

Excel Tips Hide or Remove All Unused Rows and Columns in Excel

How to Delete Blank Rows in Excel

How to Delete Blank Rows in Excel

HOW TO DELETE BLANK ROWS WITHOUT LOSING DATA [THE RIGHT WAY]

HOW TO DELETE BLANK ROWS WITHOUT LOSING DATA [THE RIGHT WAY]

10 Super Neat Ways to Clean Data in Excel

10 Super Neat Ways to Clean Data in Excel

Excel for Beginners The Complete Course

Excel for Beginners The Complete Course

How to Remove Blank Rows in Excel | 3 Methods to Delete Empty Cells

How to Remove Blank Rows in Excel | 3 Methods to Delete Empty Cells

3 Ways to Switch Data in Columns to Rows in Excel (Multiple Values)

3 Ways to Switch Data in Columns to Rows in Excel (Multiple Values)

Removing Unwanted Spaces In Microsoft Excel

Removing Unwanted Spaces In Microsoft Excel

When Should You Use the Hash Sign in Excel Formulas?

When Should You Use the Hash Sign in Excel Formulas?

Multiple Dependent DropDown List in Excel | NEW Simple Method | Works with multiple rows

Multiple Dependent DropDown List in Excel | NEW Simple Method | Works with multiple rows

Removing Blank Rows in Excel 2 DataSets, 4 different approaches and a clear winner Power Query

Removing Blank Rows in Excel 2 DataSets, 4 different approaches and a clear winner Power Query

Easily Change CASE of Text in Excel (3 ways including NO Formulas)

Easily Change CASE of Text in Excel (3 ways including NO Formulas)

Fastest Way to Delete Empty Rows in Excel (New)

Fastest Way to Delete Empty Rows in Excel (New)

How to Remove Blank or Empty Cells from rows and columns in Microsoft Excel

How to Remove Blank or Empty Cells from rows and columns in Microsoft Excel

How to delete infinite rows in Excel

How to delete infinite rows in Excel

Excel Highlight rows and records

Excel Highlight rows and records

Insert a Blank Row Between Each Data Row or Record in Excel

Insert a Blank Row Between Each Data Row or Record in Excel

Recommended

Haunted Souvenir Makes Star Guest Shiver!

Haunted Souvenir Makes Star Guest Shiver!

03:39

The Hard Life Of A Typical Man Friend

The Hard Life Of A Typical Man Friend

03:05

Every Best Friend's Sister Ever

Every Best Friend's Sister Ever

05:29

Skydivers Mark A New Milestone In The Chapter Of Human Flight

Skydivers Mark A New Milestone In The Chapter Of Human Flight

11:53

Bella The Grizzly Bear - Most Tender Wild Animal Ever Seen!

Bella The Grizzly Bear - Most Tender Wild Animal Ever Seen!

01:22

Best of Dude Perfect - Adrenalin Bomb Of The Year 2016

Best of Dude Perfect - Adrenalin Bomb Of The Year 2016

07:10

Chihuahua Catches Bubbles - Sweet Slow Motion

Chihuahua Catches Bubbles - Sweet Slow Motion

00:57

Russian Accent VS Sushi Gadget Test - What's Worse?

Russian Accent VS Sushi Gadget Test - What's Worse?

01:01