Excel delete empty rows

Question

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?

basiljames · Accepted Answer · 2012-09-25 06:12:18Z

4

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.

answered Sep 25, 2012 at 6:12

basiljames

4,8574 gold badges27 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Siddharth Rout Over a year ago

+ 1 One can also use =CountA()

Collectives™ on Stack Overflow

Excel delete empty rows

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related