Hiding amounts


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??
 
Ad

Advertisements

R

Ron100

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

Otto Moehrbach

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

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top