How to just protect formulas in cells?

  • Thread starter Thread starter Sunny
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

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

Similar Threads

Grouping on protected worksheets 4
Insert Copied Rows or Drag/Drop Formulas While Protected 2
How can i protect a formula and still allow copy and move data? 1
Insert/ delete row in protected worksheet 7
hide columns on a protected sheet 2
Allowing sort of protected cells 1
Lock a formula to a column of cells 6
Excel How to add numbers in same cell? 2

Back
Top