We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

protect formats of a cell but allow value to be changed ?

asked 2020-01-21 21:07:25 +0200

Pete of Ebor gravatar image

updated 2020-08-07 20:05:37 +0200

Alex Kemp gravatar image

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 ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-21 21:31:45 +0200

m.a.riosv gravatar image

You can use a trick, activating Menu/Tools/Share spreadsheet

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-21 21:07:25 +0200

Seen: 102 times

Last updated: Jan 21 '20