Not printing rows with a zero value

[jski]

I have a spreadsheet that has multiple rows with a zero value in the
total column. I would like to print the spreadsheet but not print rows
with zero value. I don't want to just hide the zero value rows since
depending on the update of data, zero value rows may change with
updates.

 

[Pete_UK]

Apply autofilter to the total column, and on the pull-down select
Custom ... then Does Not Equal and put 0 (zero) in the other box - this
will hide them temporarily. Once you have updated the values in the
future, just re-apply the custom filter.

Hope this helps.

Pete