Hiding amounts

[sunshine09]

Is there a way to keep the formatting in a cell, but hide the amounts? I have
a document that is adding amounts and my employer doesn't want to see the
running total all throughout the document. Any ideas??

 

[Ron100]

You could hide the column containing the running total or change the text
colour to white (or your background colour).

 

[Otto Moehrbach]

Select a white font color in all those cells. Or, if the layout permits,
hide the unwanted columns/rows. HTH Otto

 

[Gord Dibben]

Format the cells to Custom ;;;

You will still be able to see contents and/or formulas in the formula bar,
however.

If you want to hide them you must format the cells to Protection>Hidden then
protect the worksheet.


Gord Dibben MS Excel MVP