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


You'll find several options on-line. Like here: .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: 


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 :)