software

I have Excel 2003 and am attempting to protect my worksheet, but need to
allow others to be able to sort and filter data. I've followed the
instructions given by MS' quot;Help,quot; but for some reason others are not able to
sort/filter data.

The entire range to be sorted must have cells quot;unlockedquot;.

Select range A145 and set those cells to quot;unlockedquot;.

Protect the sheet and you can sort that range.

The Auto-Filter must already invoked before protecting the sheet.

Select columns A and Datagt;Filtergt;Autofilter to get the dropdown arrows.

Protect the sheet.Gord Dibben Excel MVP

On Tue, 13 Dec 2005 09:36:03 -0800, quot;valveraxquot;
gt; wrote:

gt;I have Excel 2003 and am attempting to protect my worksheet, but need to
gt;allow others to be able to sort and filter data. I've followed the
gt;instructions given by MS' quot;Help,quot; but for some reason others are not able to
gt;sort/filter data.