Forum Discussion
Prevent empty rows from printing
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.
- AndyT410Mar 20, 2023Brass ContributorHi Riny,
My company doesn't allow access to forums. Would you be able to repost that here?- Riny_van_EekelenMar 20, 2023Platinum Contributor
But this is also a forum???
Those links contain lots of advertising and quite many posts back and forth. Perhaps you can access them from home 🙂