Hiding amounts

  • Thread starter Thread starter sunshine09
  • Start date Start date
S

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??
 
You could hide the column containing the running total or change the text
colour to white (or your background colour).
 
Select a white font color in all those cells. Or, if the layout permits,
hide the unwanted columns/rows. HTH Otto
 
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
 
Back
Top