How to protect a column?

X

xpucto

Hi!

I would like to protect some hidden columns. When I choose
"protection" in the menu, I only find the possibility to define area to
be modifed but I would like to do the opposite: define which areas can´t
be modified.

How can I do this?

Thanks.
 
X

xpucto

Is there some kinf of options to protect all hidden columns? Or to
protect functions?
 
D

Dave Peterson

Cells are locked or unlocked.
Worksheets are protected or not protected.

If you lock all the cells you want to stop changes, then protect the sheet,
won't you have what you need?

In xl2002+, you can allow some users (who know a password) to change certain
ranges. But I don't see how that would affect any locked cell on a protected
sheet (if you didn't use this extra granularity feature).
 
Top