Forum Discussion
Prevent empty rows from printing
I have copied the formulas down several hundred rows, because it is a template that will receive different sized files. So there are several hundred rows with formulae in them, but they show up blank, because i used if command to make empty cell instead of 0 value cell the problem is, when I want to print, Excel wants to print all of the cells with entries in them - even the ones with formulae in them that are blank.
Is there any way to prevent the empty cells from printing?and I would like to avoid printing the blank cells.
attaching my file for example.
Thank you.
i hope i get my solution
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.
- Hi Riny,
My company doesn't allow access to forums. Would you be able to repost that here?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 🙂
