How to just protect formulas in cells?

S

Sunny

I want others allow to add/edit rows, but I want to protect formulas in
cells and in those cell they should not able to change anything.

Any idea?

Thanks.
 
A

Aamir Hashmi

Hi
Select the whole work sheet from left upper corner between Column A
Row 1
Go to format >cell >protection & untick the "Locked" Now select th
cells with formula you don't want permission to anyone to edit & agai
go to format >cell >protection & tick the "Locked". Now go t
Tools>protection>Protect sheet &
Tick the Select locked cells,insert rows, insert columns.
This will protect your formulas & will allow other to insert rows
columns & edit rows.
Pls. ask for any further help.

Aami
 

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