Prevent empty rows from printing

Copper Contributor

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

3 Replies

@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.

Hi Riny,
My company doesn't allow access to forums. Would you be able to repost that here?

@AndyT410 

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 🙂