如何在保留一些具有零值的列的同时删除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屋!