| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When printing - ability to not print empty or $0 cells
In Lotus, I used to place double pipes "||" within a print range and this
would keep rows that had a zero value from printing. Thius was very useful when prining long invoices. It keeps rows that have a zero value from prinnting, thus only printing the rows that have a total in them. Does anyone know how to do this in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When printing - ability to not print empty or $0 cells
Excel doesn't have that ability.
Maybe you could use data|Filter|autofilter and hide the rows that are zero? Briant wrote: In Lotus, I used to place double pipes "||" within a print range and this would keep rows that had a zero value from printing. Thius was very useful when prining long invoices. It keeps rows that have a zero value from prinnting, thus only printing the rows that have a total in them. Does anyone know how to do this in Excel? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NOT Printing certain cells within the print range | Excel Discussion (Misc queries) | |||
| Ability to Right Click to print | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| Need ability to leave certain cells of an worksheet editable. | Excel Discussion (Misc queries) | |||
Linear Mode
