View Locked Cells?

K

Ken

Excel 2000 ... I wish to see which cells are Locked &
Unlocked on my spread sheet ... Is there an easy way? I
tried "GO TO", however, Locked Cells was not one of the
choices ... Thanks ... Kha ...
 
D

Dave Peterson

Can you use Format|Conditional Formatting (or are you using that for something
else)?

If you can use it, you could:
select your range (say A1:x99)
and with A1 the activecell
format|conditional formatting
formula is:
=CELL("Protect",A1)

(xl will adjust the formula for all the cells in the selected area.)

And give it a nice shaded pattern.
 
Top