ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Not-printing cells/formulas (https://www.excelbanter.com/excel-discussion-misc-queries/134517-not-printing-cells-formulas.html)

CHallisy

Not-printing cells/formulas
 
I have formulas that will result in zero, or no text being displayed.

For instance:
=if(a15,"DISPLAYED","")

When the false value is returned no text is displayed in that cell, but the
cell still prints blank.

So, if I have three pages full of such formulas, they will all print every
time. Short of selecting a print range manually, or setting a print area, is
there a way to set blank cells such as these not to print?


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com