If K is your last column, put this formula in cell L3 and copy it down

=COUNTIF(H3:K3,"")=4

Then filter on column L = True

Beware that it will show false if there are any cells containing only spaces


"Kelly" wrote:

I am trying to hide rows in a sreadsheet. I have 150 stores running from A3
to A153. When they call in for an order I either put the quantities in H, I,
J or K. How can i set up a button to hide all rows that do not have data in
H, I, J or K?