Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video we look at 3 WAYS to delete blank rows in Excel with Filters, Formulas, and a VBA Macro. These techniques focus on deleting or removing entire blank rows from a worksheet.

This is a common task for exported reports, and we need ways to delete the blank rows quickly.

I explain how to filter for blanks, how to create a column of COUNTA formulas to count all the cells in a row that are not empty, and how to use a macro to quickly select the blank rows.

Here are the links mentioned in the video:
Download the file with the macro & read the full article: https://www.excelcampus.com/tips/delete-entire-blank-rows/
Beginner's Guide to Excel Tables Video: https://youtu.be/fJnJTff4Na8
How to turn off Table formulas (structured references):
https://www.excelcampus.com/library/turn-off-structured-references-table-formulas/
Excel Filters Training 3 Part Series: https://www.youtube.com/playlist?list=PLKbOx3gUV_E-eJGxHn1mJQDxYlX1ErGyO
Personal Macro Workbook 4 Part Series: https://www.youtube.com/playlist?list=PLKbOx3gUV_E_tY-0oSzMw4NE0oFy5sI0_