Use Data|Auto Filter and Filter on Quantity and exclude blank cells.

You can provide a button which can do this through a macro and then print..
You can record the macro yourself and attach to the button...

Send me mail with sample file if you need help...

"Jim Office Supply Store Owner" wrote:

I have an excel 2007 spreadsheet I use to give to my customers for filling
out orders. It lists the product and quantity and total on each line.

I wondered if there was a way to print only the lines with a quantity
entered when completed. It would save the customer a ton of paper...