Are you using Format|conditional Formatting?

If no, you could use that to shade the locked cells.

Select your range (assuming A1 is the activecell in that selection)
format|conditional formatting
formula is:
=CELL("protect",A1)

Format to your liking.

======
I use this:
Tools|customize|commands tab|Format category
Near the bottom of that list of icons/commands is: Lock Cell.
(drag it to your favorite toolbar)

It's useful for toggling the lockedness of a cell. But you can select a cell,
look at that icon. If it's depressed, the cell is locked. If it's not
depressed (happy as a clam???), then the cell is unlocked.



Kmagg wrote:

I have a large spreadsheet that has alot of single cells that need to be
locked. Is there an easy way to see the locked/unlocked status of the cells
on a spreadsheet? Maybe by having locked cells shaded? Thank you for any help
anyone can give.

--

Dave Peterson