如何在保留一些具有零值的列的同时删除MS Excel 2016中的所有零列? [英] How to remove all zero columns in MS Excel 2016 while keeping columns that have a some zero values?

问题描述

我有10行X 50000+列.问题是有些列的所有值均为零. 我只需要删除那些列，而保留那些具有零单元格的列. 下面显示了一个示例

I have a 10 rows X 50000+ columns. The problem is that there are some columns having ALL Zero values. I need to remove only those columns while keeping the ones that have a few zero cells. an example is shown below

所以它会变成这样:

推荐答案

全选>复制>(新的excel工作表/文件)在A1中右键单击>(特殊粘贴)转置

Select all > copy > (new excel sheet/file) r-click in A1 > (paste special) transpose

在K1单元格中:

=if(sum(A1:J1)=0,1,"")

并将公式向下拖动.

然后突出显示单元格A1:K1>数据>过滤器 过滤列K>选择"1"

Then highlight cell A1:K1 > Data > filter Filter column K > select "1"

然后选择所有行(通过选择左侧的行)> r单击(在左侧)>删除行.

Then select all row (by selecting rows at left side) > r-click (at left side) > delete rows.

删除过滤器，删除K列，全选>复制(另一个新的Excel工作表/文件)，然后右键单击A1>(特殊粘贴)转置.

Remove filter, delete column K , select all > copy (another new excel sheet/file) r-click in A1 > (paste special) transpose.

完成.

希望有帮助.

这篇关于如何在保留一些具有零值的列的同时删除MS Excel 2016中的所有零列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！