Hi!
I have a very big excel sheet (6000 (row)*16000(column)), in which in some of them the entire columns have zero value. Does anybody knows how to remove those columns (just not manually)?
Hola.
Si lo que deseas es solo borrar la información con el valor de 0, oprimes control b. o mejor la opción de buscar y reemplazar, colocas en el valor a buscar el valor de 0 y seguidamente en el valor de reemplazar no colocas nada.
Te aclaro, esto, no te borra las columnas , pero si te borra cada valor de 0 que te aparece.
hasta pronto
One way would be to SUM each column at the bottom of the document, you can then sort the entire document based on this row from smallest to biggest, and then just delete all the columns that have zero sum. This will be easy and quick since they will all be located first in one big section.
First, before doing the above, you should add one row of just the index (from 1 to 16k) of the original design of the document, so that you can revert it back after deleting the zero columns, and then just sort based on this index from smallest to biggest.
Zero-value sums will be OK if numerical values in the sheet are all non-negative. If they may be negative, too, then accidentally the sum may be zero even if non-zero elements exist eg. 0+0+...+0+(-2)+1+1+0+...+0+0
- Badges
- Science topic