View Locked Cells?

  • Thread starter Thread starter Ken
  • Start date Start date
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 ...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Locked Cells ... How 5
How unlock locked cells 2
Cell Protection? 2
Locked cells are still able to be selected with proper protection 1
How can I remove the previous lock cells and keep the new ones. 2
View which cells are locked? 1
Problem tabbing between merged cells in Excel 2010 0
VB Coding 1

Back
Top