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
|