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
Dynamic Print Range with cells containing formulas ! 1
How to best select from image and print full size? 1
Variable print area via a macro 9
After Macro runs, no cell activated - what am I missing? 2
Displaying & Printing cells with lotsa text 2
Printing truncates cell contents 6
Help on Macro to hide empty rows 4

Top