Ask Your Question

See what cells are protected and not?

asked 2016-06-12 23:34:18 +0200

woosting gravatar image

updated 2020-08-07 22:03:05 +0200

Alex Kemp gravatar image

Is there an easy way to create an overview of which cells in a sheet are protected and which are not (after having (un)protected some cells by having protected the sheet)?

I'm asking for something in contrast to having to select each cell(region) and checking [Format_cells...].

Instead I'm searching for something similar as deployed in proprietary Google Docs for instance: the protected cells being marked with a diagonal strike-through pattern or something along those lines.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-06-13 01:22:40 +0200

m.a.riosv gravatar image

I think not, but when protecting the sheet there is an option to make selectable 'protected' and/or 'unprotected' cells.
So making selectable only unprotected cells you can move only through those cells, with tab key or with the mouse, and with arrow keys between adjacent cells.

Instead using a direct format to unprotected cells, creating a style with the 'protect' option disable and a different background color.

With CELL("protect") function can be created a conditional formatting.

image description

edit flag offensive delete link more


Excellent! Thank you for answering; I would upvote but my karma level does not allow for it (yet).

woosting gravatar imagewoosting ( 2016-07-27 17:14:42 +0200 )edit

answered 2019-05-19 14:00:58 +0200

pierre-yves samyn gravatar image


Obviously too late for the OP but for the record , with ViewValue Highlighting protected cells are shown with light grey background when the sheet is protected

See help.


edit flag offensive delete link more


Thank you! This answered my question and helped me!!!

Pushbutton2 gravatar imagePushbutton2 ( 2020-04-26 18:03:38 +0200 )edit

Question Reopened due to inappropriate answer selected (Pierre's answer seems more appropriate)

appreciatethehelp gravatar imageappreciatethehelp ( 2020-12-14 00:33:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-12 23:34:18 +0200

Seen: 840 times

Last updated: May 19 '19