CODEWITHSUNDEEP
excelexcel-2007vba
user1577161
user1577161

Reputation: 175

Excel delete empty rows

I want to delete rows which are completely empty. For example, I have a sheet with at least 10 rows and 5 columns. Some rows don't have a value in ColumnA but do in ColumnB. Other rows have no value in any column. How can I delete those rows with no value at all but keep those rows with a value in at least one column?

Upvotes: 0

Views: 1661

Answers (1)

basiljames
basiljames

Reputation: 4847

I'll answer as continuation to your example. Goto a new column (6th Column), write formula using CONCATENATE function to concatenate values of columns 1 to 5. Drag the formula to all rows of column 6. Now you can see that column 6 will have blank values only if columns 1 to 5 are blank. Now you can autofilter column 6 to show only blank values and delete those rows.

Upvotes: 4

Related Questions