is there a visual check for locked cells in excel?

  ernieernie 21:02 12 Sep 06
Locked

Is there a visual check for locked cells in excel?
I am the author and maintenance man for a rather complicated excel spreadsheet Many cells are locked but they are widely distributed in the spreadsheet.
I remember that over twenty years ago, that in Supercalc, when a cell was locked there was a visible indicator of the fact but I cannot find a way to make excel do the same.
It is a frustrating job trying to check what is locked and what isn't. Surely excel ought to have a facility for this. Can anyone help?

  STREETWORK 21:05 12 Sep 06

Select the cell, select format, remove the tick in 'locked'

  ernieernie 21:26 12 Sep 06

Thanks for the effort, Streetwork, but that means I have to select every cell in order to check.
What I meant was that there ought to be a way to see if a cell is locked without having to go anywhere. I know that I could colour the cells differently to show whether or not they are locked but that is yet another job and it limits my use of colour for other purposes.

  VoG II 22:16 12 Sep 06

If these cells contain formulas, go to Edit > Go to, click the Special button and select Formulas then click OK. Cells containing formulas will now be selected. Now go to Format > Cells and select the Patterns tab and choose a colour.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…