When printing - ability to not print empty or $0 cells

B

Briant

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?
 
D

Dave Peterson

Excel doesn't have that ability.

Maybe you could use data|Filter|autofilter and hide the rows that are zero?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I suppress printing a row without hiding it? 5
Displaying & Printing cells with lotsa text 2
Help on Macro to hide empty rows 4
After Macro runs, no cell activated - what am I missing? 2
Numbering rows when printing 7
show empty cell when result is 0 2
How can I get vacant lines in a sheet to not print 2
Print Selected Items in Excel Order Form 10

Top