Excel删除空行 [英] Excel delete empty rows

问题描述

我想删除完全为空的行.例如，我有一个至少有10行5列的工作表.有些行在 ColumnA 中没有值，但在 ColumnB 中具有值.其他行在任何列中都没有值.我该如何删除那些完全没有值的行，而将那些具有值的行保留在至少一列中?

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?

推荐答案

我将作为您示例的续篇回答.转到新列(第6列)，使用 CONCATENATE 函数编写公式以串联第1至5列的值.将公式拖到第6列的所有行.现在您可以看到第6列将有空白仅当第1到5列为空白时才使用值.现在，您可以 autofilter 列6仅显示空白值并删除这些行.

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.

这篇关于Excel删除空行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！