how can identify locked/hidden cells at a glance

D

Dave Peterson

For hidden cells, I don't think you can do anything besides look and not see
them <g>.

But for locked cells, you can use format|conditional formatting (if you're not
using it for something else).

With the range you're concerned about selected, you can use a formula like:
=CELL("protect",A1)
(Change A1 to the activecell)




Merlin wrote:
 
Top