Stop formula solution of "" or 0 from printing

[STS_offices]

I have searched but cannot find an answer. I have a list of formula’s that extend for several pages, these formula point to an external CSV file, which varies in size. I do this to automatically format the CSV without having to repeat the process over and over again. I instead just open and print. It is almost perfect but formula’s with empty values still print. I have disabled printing of 0 values, and enabled empty formula is 0 value and it doesn’t work. I’m not sure if this is even possible.

Thank you

[erAck]

Not printing 0 values means only the 0 will not be printed but blank instead, similar to the view option. You can either select the cells to be printed and then print only Selected cells, or define a print range that covers only the to be printed cells if you want to repeatedly print the same range, menu Format → Print Ranges → …