How to hide rows that return zero values in each column

[Tracy2573]

Hello,

I have multiple columns that have formulas in each column, but if every column returns a zero value then I would like to hide the rows. However, I cannot use the Group/Ungroup options as the workbook is shared and these options are not available when you are sharing.

My columns go from A-V and could be 200 lines. So it is very time consuming to hide them all one by one. My data that I need to potentially filter always starts on row 10.

 

[Tracy2573]

I should have mentioned as well that I do also have lines that have no data in them because the first column is just a name, so I would need to keep these visible.

 

[BSALV]

make an auxiliary column W with a formula which results in a "1" to remain visible and a "0" to be hidden.
Autofilter on that column W

Map1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
3																							show
4	only tekst																						1
5	tekst+formulas						120																1
6	tekst+formulas						0																0
Blad2

Cell Formulas
Range	Formula
G5	G5	=+ROW()*24
G6	G6	=+ROW()*0
W4:W6	W4	=--AND(A4<>"",OR(COUNTA(B4:V4)=0,SUMPRODUCT(ISFORMULA(B4:V4)*(B4:V4<>0))))