Saving Formulas in Excel

  • Thread starter mrsirishvasicek
  • Start date
M

mrsirishvasicek

I need to find a way to protect a formula in an Excel Worksheet. I wan
to put the formula in and allow others to post their data in th
worksheet, but I don't want it to affect the formula. Is there a way t
accomplish this
 
G

Gord Dibben

By default all cells in a sheet are locked when you protect the sheet.

Select all cells and Format>Cells>Protection........unlock them.

Now select those cells you want locked and Format them to locked.

Now protect the sheet............your formula cells cannot be edited
but referenced cells can be filled.


Gord
 
Top