Automatically not print rows in Excel with a zero value?

[Guest]

I use Excel for billing invoices.
Have over 100 items.
Never use all items.
I manually delete each row so invoice is not 3 pages long.
Don't want to show all these no value rows.
Would like to have Excel only print the rows that contain a value--so I
don't have to eliminate these rows every time I create a new invoice.

 

[JulieD]

Hi DJP

just an alternative approach, why don't you design the invoice for the
"average" number of items you have (and so it looks pretty on 1 page) and
then add rows in if you need extra ones?

i have an example invoice workbook with code that does this (the adding rows
bit), if you'ld like to email me direct (julied_ng at hcts dot net dot au)
i'll be happy to send it to you and you can maybe adapt it for your use.

Regards
JulieD

 

[Dave Peterson]

How about applying Data|filter|autofilter to that range.

Then filter to show just the nonblanks.

Print and data|filter|showall to bring them back.

 

[Dave Peterson]

And if you mean zero, you could filter and just show the rows with values > 0
(it's under the Custom option on the filter dropdown).