I have a table where the highlighted cells contain formulas in which I do not want anyone to be able to edit:
The reason I have built a table is so that once I enter new data on the forth row for instance, the formulas in the highlighted cells should auto calculate themselves.
The issue I am having is trying to prevent any edits to the formulas I have in the highlighted cells while still have the formula automatically calculate once I have filled data for column 1 and 4 for new rows added.
What I did try was locking the cells by doing the following:
- Highlighted all of the cells in the worksheet
- Made sure that the highlighted cells were unlocked:
- Locked the columns where the formulas would be:
4.Selected Protected Sheet:
- Now that the highlighted columns are protected and no one is able to edit them, I lost the ability to have those columns auto calculate for new rows when I enter new data in new rows:
