Locking some cells and hiding formula

P

parag

I have made some calculation for material planning. I want to hide the
formulas and at the same time i want to lock the cells where i get output,
but i don't want to lock the cells where I input the data.
This i want when i give it to someone else.
 
A

Allllen

two steps:

1) For the cells where you want to lock and hide the formula
Do Format > Cells > Protection choose locked and hidden
For other cells where you will input data, which will not be locked, choose
unlocked and unhidden

2) do tools > protect worksheet. choose the actions you want the user to be
able to do.
 
Top