General discussion


Locked Cells Excel

By gmelton ·
I frequently use cell protection in Excel to protect formulae and values while leaving others unlocked for data entry.
Is there an easy method of displaying the current status of cells without having to look at the FORMAT of each cell? Something like the BOLD icon in the Toolbar would be useful.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Alpha48 In reply to Locked Cells Excel

Simply use colors in the cells, either the font or the entire cell. A second distinction would be to put a border around the cell or any part thereof....


Collapse -

by gmelton In reply to

Poster rated this answer.

Collapse -

by dryflies In reply to Locked Cells Excel

good idea by alpha48. to expand on that you could use conditional formatting to color those cells that are locked.

Collapse -

by billd In reply to

Good suggestion. Took me a little while to figure out the specific formulas to use with conditional formatting.
To add formatting to all protected cells, highlight the sheet and enter:
To add formatting to all non-protected cells (i.e. to show users where entries are protected):

Collapse -

by mike_dee In reply to Locked Cells Excel

simple but effective method

format one specific cell with a different pattern or font AND LOCKED.

Then use the Format Painter Icon to copy that format to other cells that contain formulae/values.

if you want cells to be automatically formatted whenever they contain values/formulae, you could use Format/Conditional Formatting or alternatively, VBA, for that.

hope this helps


Related Discussions

Related Forums