Print Only Non-blank or Nonzero Rows

[Waverly]

Without programming or VBA routines, is there the ability to print lines with entries on them?

The attached spreadsheet, I'd like not to print the rows that do not have any entries in the debit/credit columns.

[6StringJazzer]

There is no way to do this in the print setup or the print operation. You will have to filter out the rows you don't want to print.

Set print area to columns A:G
In column H add a header in H5 that says PRINT
Fill column H with this formula

Please Login or Register  to view this content.

Select the table and click Data > Filter
Click the dropdown in H5 and uncheck False
Print the sheet

[Waverly]

Thx, it seems to work; fine tuning it now.

[Waverly]

Thanks, adding that header filter column does seem to select only those rows with entries on them, but, I'm noticing it's messing up my alternate row shading format, but we can live that.

[Waverly]

And, forgive me for saying this, for I mean it to be a compliment.

That is very good "out-of-the-box" thinking to come up with that formula to use in a filter for printing.

[6StringJazzer]

Change your conditional formatting rule to the following to alternate colors only on the visible rows.

Please Login or Register  to view this content.

[Waverly]

Thank you again!!!!