I want to remove some data from a sheet before I send it the protected sheet to clients. I have a column with Qty with data validation values of 0, 10, 50, 100 for each row. I want to hide all the rows where the value is 0 so the client can't see them in a filtered or un-filtered view. I will protect the sheet as well so they can only filter the table. I tried hiding the rows and then protecting the sheet but it still allows you to filter with value 0 as an option.

Is there a way to hide these rows without deleting the rows that contain this value?