Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Alternate Rows | Excel Discussion (Misc queries) | |||
printing worksheet with hidden rows | Excel Worksheet Functions | |||
Hide Empty Rows When Printing | Excel Worksheet Functions | |||
printing only selected rows in a sheet | Excel Discussion (Misc queries) | |||
Printing problems with columns and rows | Excel Discussion (Misc queries) |