View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
slwaite
 
Posts: n/a
Default How do I hide text from printing?

I am using Excel 2003. Is is possible to hide a specific cell's contents
from being printed? This cell has a formula that pulls confidential
numerical information from another sheet in the the workbook. This number is
then combined with other cells to give either a positive or negative number
in regards to actual job hours used on a project.

I need to be able to show the positive or negative number without showing
what the various components are when the workbook is printed. I have tried
using the hide option of the worksheet but it only hides formulas not the
text created from the formula. Can anyone help me with this problem?