How to Delete Blank Rows in Excel (Step-by-step Guide)

While working with large datasets in Excel, you may need to clean the data to use it further. One common data cleaning step is to delete blank rows from it.

Now there are various ways to delete blank rows in Excel:
-- Go to each blank row and delete it manually (too tedious and time-consuming).
-- Sort the entire data set so that all the blank rows are at the bottom (works but alters the data set).
-- Use Go To special technique to select all the blank cells at once and delete the rows (way to go).

In this video, I will show you how to use Go To Special dialog box to quickly select blank cells and then delete these from the data set.

I will also show you how to use Go To Special dialog box to select blank cells and then format these or enter some placeholder text in it (such as 0 or Not Available).

You can read more about this technique here (where I also cover how to delete blank rows with VBA in Excel): trumpexcel.com/delete-blank-rows-excel/


Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial