Ask Your Question
0

See what cells are protected and not?

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

woosting 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
0

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

Comments

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
1

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

pierre-yves samyn gravatar image

Hi

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.

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 376 times

Last updated: May 19