Hiding Cell Contents from the Printer !

Need to produce a printout where certain cells (not an entire row or column, you could right-click and Hide them) in the print area need to be hidden?


One trick is to set the font color in those cells to white.

1. Select the cell(s)
2. Format | Cells
3. In the Format Cells dialog box click the Font tab
4. Click the arrow at the right side of the Color list box and select white from the list
5. Click OK to close the dialog box and apply your new font color
6. Print the worksheet without showing the unwanted cells. After you finish printing, select the cells again and set the color back to black (or automatic).

Best Regards,