This sounds like a good place for using auto filter
select a column which would be blank for the rows you would not want to show
when printing.
Select non blank from the auto filter options.

"CarSum" wrote:

I work a lot in spreadsheets that are linked together. Eg I enter data on
one sheet it is recalculated and placed on another spreadsheet that has
multiple rows of data on it. I then delete the lines that have no data from
previous sheet on it to print a neater form. Can I somehow get these rows
that have a zero valu in a certain column not show up when I print instead of
manually deleting them one by one.
Thank You for any help you may be able to give me.