Hi. I have a number of spreadsheets which I use for the accounts of several clubs. I am confident with using cell protection to protect those cells which I do not want to be changed (such as the results of calculations) but for the cells where I need an input, they need to be left unprotected. Is there a way to ‘partially’ protect a cell so that the actual value in the cell can be changed but that other attributes like formatting/fonts/alignment/text colour/background colour etc cannot be changed ?
You can use a trick, activating Menu/Tools/Share spreadsheet