Not printing rows with a zero value
 

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.




--
jski

Not printing rows with a zero value
 

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

jski wrote:
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.




--
jski