Prevent empty rows from printing

aanis143

You'll find several options on-line. Like here: 

https://www.excelforum.com/excel-formulas-and-functions/484040-prevent-empty-rows-from-printing.html .This one ends up with a formula that dynamically sets the print area.

Another one suggests to include a piece of VBA that hides blank rows before printing like here:

https://www.extendoffice.com/documents/excel/3319-excel-print-without-blank-rows.html 

But, may I assume that all your columns have a header? If so, why not simply put a filter on them and exclude blanks before you print. A one-click solution that requires no programming or rather complicated formulae.