Thread: HIDING FORMULAS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Huber57 Huber57 is offline
external usenet poster
 
Posts: 74
Default HIDING FORMULAS

Zen,



Select the range of cells whose formulas you want to hide. You can also
select nonadjacent ranges (nonadjacent selection: A selection of two or more
cells or ranges that don't touch each other. When plotting nonadjacent
selections in a chart, make sure that the combined selections form a
rectangular shape.) or the entire sheet.
On the Format menu, click Cells, and then click the Protection tab.
Select the Hidden check box.
Click OK.
On the Tools menu, point to Protection, and then click Protect Sheet.
Make sure the Protect worksheet and contents of locked cells check box is
selected.

Caution - This procedure also prevents the cells that contain the formula
from being edited.


"zen" wrote:

I need to sent my file to our customers, I dont want them to see my
formulas. How I can hide them? They are adding rows and changing values so I
cannot fully protect my file before sending.