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?

The way I see it, you have 3 choices;
Insert a helper column, move your formula to this column, then hide the
column.
Insert a row, move your formula to this row, then hide the row.
Change your font colour to white, so it cannot be seen.

"slwaite" wrote:

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?

You might use Conditional Formatting to change the color of the text in the
cell of concern to the same as the background color in accordance with a key
number located in a certain cell.....that is to say that if the code number
X123 were typed in to cell A1, then the Text in that cell would be BLACK, but
if it were not, then the text would be the same as the background
color...essentially invisible to a printout

Vaya con Dios,
Chuck, CABGx3





"slwaite" wrote:

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?