Can I protect cells so that users cannot change entries
I have a spreadsheet that other users can enter data into. But, I do not want them to be able to change values of a cell that are generated by the spreadsheet.
iMac, OS X Yosemite (10.10.1)
Question marked as
Best reply
separate user entry from calculations by putting them in separate tables. Lock the table with the calculations using the menu item "Arrange > Lock"