Printing only rows with information

I have a very good spreadsheet for pricing a system, but usually only about a third of the items will be called for in the system quote. Is there a way I can have only the rows which have quantities ordered print out?

This is marked as Solved - did you get an answer to the problem elsewhere?

Pete

No, it is not solved, I may have made a mistake in posting this.

Okay, will one way of doing it would be to have a formula to one side which picks up the individual prices, and then apply autofilter on that column and de-select zero values each time you want to print.

Hope this helps.

Pete