Excel 2003: Protection

[Guest]

I have a spreadsheet in which I need to lock two columns so they cannot be
changed. I don't need to lock or protect the entire spreadsheet as others
have to be able to use the dropdown arrows for filtering.

How do I do this?

 

[Gord Dibben]

You can use autofilter on a protected sheet if you set the autofilter before
protecting.

See Debra Dalgleish's site for instructions with pictures.

http://www.contextures.on.ca/xlautofilter03.html#Protect


Gord Dibben MS Excel MVP