View Single Post
  #1   Report Post  
dill_weed
 
Posts: n/a
Default prevent empty rows from printing

I have formulae in cells to reference another sheet, but if the referenced
cell is blank, then the new cell I made blank (using the IF function). 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?